Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge excel data incuding email address
I am using OfficeXP and I would like to know how to create a mail merge that
pulls the merge fields from a Excel including...this is the hard part...the email address that I am sending to. Here's how I have it set up Headings Cell A1: Name Cell B1: Login ID Cell C1: Email Address 1st Row Cell A2: John Cell B2: John2007 Cell C2: In Word, my email message would read "Hello John, your new login id is John2007. If any questions, please let us know." I need cell C2 to be the email address I am sending to, however. I don't want to create a list and send everyone on the list eveyrbody's login names. How can I do that in Word 2003? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge excel data incuding email address
Execute the merge to email and then you will be asked for the field in the
data source that contains the email addresses. After selecting that field, individual emails will be sent to each email address in the data source. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Bolzey" wrote in message ... I am using OfficeXP and I would like to know how to create a mail merge that pulls the merge fields from a Excel including...this is the hard part...the email address that I am sending to. Here's how I have it set up Headings Cell A1: Name Cell B1: Login ID Cell C1: Email Address 1st Row Cell A2: John Cell B2: John2007 Cell C2: In Word, my email message would read "Hello John, your new login id is John2007. If any questions, please let us know." I need cell C2 to be the email address I am sending to, however. I don't want to create a list and send everyone on the list eveyrbody's login names. How can I do that in Word 2003? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge excel data incuding email address
I didn't know it would actually ask for the field at the very end but just as
you said, individual emails were sent as I wanted. Thank you sir! "Doug Robbins - Word MVP" wrote: Execute the merge to email and then you will be asked for the field in the data source that contains the email addresses. After selecting that field, individual emails will be sent to each email address in the data source. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Bolzey" wrote in message ... I am using OfficeXP and I would like to know how to create a mail merge that pulls the merge fields from a Excel including...this is the hard part...the email address that I am sending to. Here's how I have it set up Headings Cell A1: Name Cell B1: Login ID Cell C1: Email Address 1st Row Cell A2: John Cell B2: John2007 Cell C2: In Word, my email message would read "Hello John, your new login id is John2007. If any questions, please let us know." I need cell C2 to be the email address I am sending to, however. I don't want to create a list and send everyone on the list eveyrbody's login names. How can I do that in Word 2003? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel data for email merge in Word 2000 | Mailmerge | |||
email mail merge -- reply to different address | Mailmerge | |||
Word 2003 Email Merge w/Excel Data | Mailmerge | |||
mail merge to a secondary email address | Mailmerge | |||
how do i create a mail merge for email using excel as a data sourc | Mailmerge |