Send Email Based On Table Array

[bigmerf]

Hello!

I have an Access Database for which I have a table including names and email addresses. What I want to be able to do have the user click a button and generate an email for each record in the table and pull the email address from the appropriate field.

Has anyone out there created any VB code for something like this? I'm assuming I'll have to create a FOR loop or something like that to read through the table until EOF, but I need help with the syntax, specifically the FOR loop as well as how to setup the email object to pull the appropriate fields into the "To", "Subject", "Body", etc.... parts of the email.

Any help from someone that has done this (or knows how) would be greatly appreciated.

Thanks!

 

[SkipVought]

Hi,

Have you considered MS Word Mail Merge?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bigmerf]

Well, I want to automate the process so that the user just clicks the button and an email is created AND sent automatically for each record in a table.

It should pull the person's name and email address from the table specifically, but I need an email for each record.

 

[SkipVought]

So automate the Mail Merge process.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[CaptainD]

This is from a VB6 forum but it should work

faq222-179