Email Merge
in [Document Management]
|
From: Texas Nuckols on 2 Mar 2010 18:10 I need to send tracking numbers to 100 different email addresses. I created a Merge doc and have my email addresses and tracking numbers in an Excel spreadsheet. How can I create the merge and send so that each email address gets only their own tracking number? I've never tried anything like this before. So I am sure I need to set this up in a special way. Please help.
From: Doug Robbins - Word MVP on 2 Mar 2010 18:33 If there is only one tracking number for each email address, it is simply a matter of setting up a letter type mail merge document that contains the mergefield for the tracking number with what ever other text that you want to appear in the message and then executing that merge to email. On selecting that option, a dialog box will appear via which you can select the field in the data source that contains the email addresses and enter a (common) subject line for the messages. It there are multiple tracking number for each email address (or some of the email addresses) and you only want to send one message to each address, See the following page of fellow MVP Graham Mayor's website: http://www.gmayor.com/ManyToOne.htm -- 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, originally posted via msnews.microsoft.com "Texas Nuckols" <TexasNuckols(a)discussions.microsoft.com> wrote in message news:1A377A95-7ECC-43A1-84BE-7E5EA1208E8B(a)microsoft.com... > I need to send tracking numbers to 100 different email addresses. I > created > a Merge doc and have my email addresses and tracking numbers in an Excel > spreadsheet. How can I create the merge and send so that each email > address > gets only their own tracking number? I've never tried anything like this > before. So I am sure I need to set this up in a special way. Please > help.
|
Pages: 1 Prev: paper jam status Next: Set up a questionaire with fill in blanks? |