#1   Report Post  
Posted to microsoft.public.word.docmanagement
Texas Nuckols Texas Nuckols is offline
external usenet poster
 
Posts: 6
Default Email Merge

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.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Email Merge

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 Mayors 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" wrote in message
...
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.


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Email Merge


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 Mayors 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" wrote in message
...
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.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge to email reverses the order of email address with addressed Rosalie[_2_] Mailmerge 1 September 8th 08 08:04 PM
Outlook Email 2 and Email 3 not availible as merge fields? Blake[_2_] Mailmerge 1 March 16th 08 04:35 PM
e-mail merge errors w/ multiple email addresses in email field Jane Mailmerge 1 December 13th 07 05:43 PM
merge a single email to all the email address for a contact Tony Mailmerge 1 July 25th 06 04:56 AM
personalized email to multiple addrs thru email merge? Citywoman Mailmerge 1 February 4th 06 09:28 PM


All times are GMT +1. The time now is 03:12 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"