Results 1 to 2 of 2

Thread: VBA in Access, send email using values in a table

  1. Aug 1st, 2007, 12:18 AM #1
    mick1982
    mick1982 is offline

    Thread Starter
    Junior Member mick1982's Avatar
    Join Date
    Jun 2006
    Posts
    27

    VBA in Access, send email using values in a table

    Hi there,

    I am currently trying to setup an automated email facility which sends an email to a designated distribution list (this is contained in a table called: tblMailShotAddresses, with the emails stored under the EMAIL column). I have the email sending with an attachment, however I cannot seem to figure out how to get my code to load all of the values in the EMAIL column into an array and then send an email to eachof these????

    Can anyone help?

    Cheers
    Reply With Quote Reply With Quote
  2. Aug 1st, 2007, 01:21 AM #2
    mick1982
    mick1982 is offline

    Thread Starter
    Junior Member mick1982's Avatar
    Join Date
    Jun 2006
    Posts
    27

    Re: VBA in Access, send email using values in a table

    Hi

    Don't worry about my query I managed to get it working using the DCount and DLookup functions.

    Cheers
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width