Loop through records to send emails 1

[JeepShaggy]

Hello. This is my first post to the forums. Please excuse any ignorance on my part.

I would like to have Access 2003 open a report and send out a record specific email to the email address associated with the record.

I have found the options in macros to either hardcode one email address that is always used, or open an email without an email address typed in.

Since I can have Access send out a report to one email address, I'm hoping I can write some code to pull the records email address, populate the report, send off a snapshot of the report, and then do the same for the next record.

Can anyone help me with this??

 

[JerryKlmns]

Would this help?
E-mail via Outlook with multiple recipients/attachments
faq705-1634

 

[JeepShaggy]

This should help get me started. I'm new to programming too, so it might take me awhile to sift through the code. I'm hoping I can figure out what I can change to personalize it for my needs.