Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word 2002 Mail Merge with E-mails Question

Status
Not open for further replies.

BBousman

Programmer
May 10, 2004
57
US
I work for McGraw-Hill and have a program that will Merge professors' information into a Word 2002 document. What I need it to do is that once it merges, it automatically sends out that e-mail to each professor in the list of professors. The only way to do that I see is with the Merge to E-mail button but that doesn't become active until you open a datasource. Can anyone help me so that when the file opens and is merged that it will automatically send out an e-mail to each professor that gets merged? Or is this impossible with 2002 because we used to be able to do this on a previous version of word? Thanks!
 
Your question is kind of confusing, let me try to clarify...If you have your list of professors merged in, then you have already selected your data source, right? Perhaps you can give some more information. You have a list of professors right? In Excel, or access or something? And you want to write them all a letter and email it, right?

Dawn

 
Dawn

The program I use lets you choose a file which is basically a template that has a datasource already hooked to it. So in the program when you tell it to merge to ProfessorEmail.doc it will merge the fields but the datasource won't be open so you can send out an e-mail. The datasource hooked to ProfessorEmail.doc is called DataProfessorEmail.doc so they're both Word files but I can't get it so when the ProfessorEmail.doc file is opened with the merged fields that it sends out an e-mail to each professor. Here's what the ProfessorEmail.doc file looks like:


Dear <<First>> <<Last>>,
<<Line1>>
<<Line2>>
<<Line3>>
<<City>>, <<State>> <<Zip>>

Thank you for choosing McGraw-Hill....etc.

Along with the fields above there are about 5 or 6 others including an e-mail address that are sent in that I want to use to send the above with merged fields to each professor. Does that help?

Brett
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top