Thread
:
Mail merge w/Excel & Outlook
View Single Post
#
2
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
Posts: 33,624
Mail merge w/Excel & Outlook
See
http://homepage.swissonline.ch/cindy...tm#ComplexMerg
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"Victoria B" Victoria
wrote in message
...
I want to mail merge the data from an excel spreadsheet into an Outlook
email.
The excel spreadsheet contains 1000+ rows of lines of data. It contains
the
following columns.
Agent Name | Agent Email | Client Name | Client Email
There are 100 different agent names/emails but 1000 different client/name
emails.
Currently I can only figure out how to send one email per agent per
client.
So the agent is receiving multiple emails with each individual client name
listed. This seems redundent.
My goal is I'd like to send ONE email to each agent. In that one email I
would like it to include the multiple rows of client name/email.
Any help is appreciated.
Reply With Quote
Suzanne S. Barnhill
View Public Profile
Find all posts by Suzanne S. Barnhill