Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help: try to send an e-mail to multiple recipiant in outlook but i
Hi,
I have been trying to perform a mail merge with Outlook 2003. I have the text of the message all set and open as an e-mail message in outlook. I next go to Tools/letters and Mailing/mail merge. I then select Document type as e-mail message. In Select Starting Document: I select "Use current document" "Select recipients" Use existing list: I point Outlook at an existing excel file using Browse. "Select Data source" box comes up and existing EXCEL file chosen. Next: "Write your letter": The text is alread open in outlook mail. Choose "Greeting Line" and Dear and Joshua and , and then match fields with first name column and greeting line place holder appears in the proper place. After this is where the problem occurs. I can't seem to be able to point mail merge so that it will take the list of e-amil address from that excel spredsheet. The e-mail is ready to send but there is nothing in the TO: line. Can anyone point me in the proper direction? I have the merge pointed to the excel spread sheet. The Place holder for the forename greeting seems to work when I link it to the excel spreadsheet but afte that I can't seem to figure out how to get the message in outlook to pull the e-mail addresses from the same excel spreadsheet so that the message can be sent. The TO: field is empty and of course that won't work. This is running on exchange server. What the heck am I doing wrong? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
try to send an e-mail to multiple recipiant in outlook but i
You appear to be trying to use two data sources (Outlook and Excel)
simultaneously. You can't do that. You only need to start the merge from Outlook if you are using Outlook as your data source. Create the document in Word, attach your Excel data source and then merge to e-mail, adding your e-mail address field from the data source, and using Outlook as your default e-mail application. http://www.gmayor.com/mail_merge_lab...th_word_xp.htm covers the basics. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Richy wrote: Hi, I have been trying to perform a mail merge with Outlook 2003. I have the text of the message all set and open as an e-mail message in outlook. I next go to Tools/letters and Mailing/mail merge. I then select Document type as e-mail message. In Select Starting Document: I select "Use current document" "Select recipients" Use existing list: I point Outlook at an existing excel file using Browse. "Select Data source" box comes up and existing EXCEL file chosen. Next: "Write your letter": The text is alread open in outlook mail. Choose "Greeting Line" and Dear and Joshua and , and then match fields with first name column and greeting line place holder appears in the proper place. After this is where the problem occurs. I can't seem to be able to point mail merge so that it will take the list of e-amil address from that excel spredsheet. The e-mail is ready to send but there is nothing in the TO: line. Can anyone point me in the proper direction? I have the merge pointed to the excel spread sheet. The Place holder for the forename greeting seems to work when I link it to the excel spreadsheet but afte that I can't seem to figure out how to get the message in outlook to pull the e-mail addresses from the same excel spreadsheet so that the message can be sent. The TO: field is empty and of course that won't work. This is running on exchange server. What the heck am I doing wrong? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help: try to send an e-mail to multiple recipiant in outlookbut i
The problem here probably results from the fact that you are composing
your message in the "Word editor" in Outlook. Typically, when you prepare a mailmerge to email with an Excel data source, you would create the document in Word as an ordinary document (i.e. you would not even see the email details box at the top of the document, like you would when preparing an email in Outlook). Then, after you have attached the Excel data source, follow the Mail Merge Wizard (assuming that is what you are using) through to the end. When you try to perform the merge, you should see a dialog box that lets you specify the format (plain text, HTML, or attachment), the Subject (which is the same for every email in the merge) and the field n your Excel source that contains the "To" address. Alternatively, you can enable the mailmerge toolbar (e.g. using View-Toolbars) and clcik the appropriate button near the right hand end to get this dialog box and perform the merge. Peter Jamieson http://tips.pjmsn.me.uk Richy wrote: Hi, I have been trying to perform a mail merge with Outlook 2003. I have the text of the message all set and open as an e-mail message in outlook. I next go to Tools/letters and Mailing/mail merge. I then select Document type as e-mail message. In Select Starting Document: I select "Use current document" "Select recipients" Use existing list: I point Outlook at an existing excel file using Browse. "Select Data source" box comes up and existing EXCEL file chosen. Next: "Write your letter": The text is alread open in outlook mail. Choose "Greeting Line" and Dear and Joshua and , and then match fields with first name column and greeting line place holder appears in the proper place. After this is where the problem occurs. I can't seem to be able to point mail merge so that it will take the list of e-amil address from that excel spredsheet. The e-mail is ready to send but there is nothing in the TO: line. Can anyone point me in the proper direction? I have the merge pointed to the excel spread sheet. The Place holder for the forename greeting seems to work when I link it to the excel spreadsheet but afte that I can't seem to figure out how to get the message in outlook to pull the e-mail addresses from the same excel spreadsheet so that the message can be sent. The TO: field is empty and of course that won't work. This is running on exchange server. What the heck am I doing wrong? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Recipiant | Microsoft Word Help | |||
"object cannot be found' msg when I try to send outlook e-mail | Mailmerge | |||
How do I change the email address I use to send mail in outlook? | Microsoft Word Help | |||
Send To: Mail Recipiant (as attachment) Not Available | Microsoft Word Help | |||
how do i send e mail with outlook | New Users |