[Victoria B]

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.

[Suzanne S. Barnhill]

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.

[Suzanne S. Barnhill]

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.

[Graham Mayor]

See if the add-in at http://www.gmayor.com/ManyToOne.htm works for you. If
not there are alternative suggestions linked from the start of that page.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site 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.

[Graham Mayor]

See if the add-in at http://www.gmayor.com/ManyToOne.htm works for you. If
not there are alternative suggestions linked from the start of that page.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site 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.

[christineberry]

If you are looking for a converter that can merge or convert your Excel
contacts list to MS Outlook, then you can try SysTools Excel to Outlook
software which is really helpful in transferring the multiple contacts
of Excel file to Outlook PST file.

The software removes duplication of contacts means Excel to Outlook
software de-duplicates Excel contacts i.e. if any Excel contact entry is
present multiple times in the Excel sheet, then it will appear only once
in Outlook.

And it also allows you to 'convert .CSV files to Outlook'
(http://www.exceltooutlook.com/) contacts. Software supports all the
version of Excel and Outlook and it also supports Windows Vista & 7.

You can try this Excel to Outlook tool from here 'Excel to Outlook to
Convert Excel to Outlook Contacts | SysTools'
(http://www.exceltooutlook.com/)

All the best

Christine Berry
'Excel to Outlook to Convert Excel to Outlook Contacts | SysTools'
(http://www.exceltooutlook.com/)


--
christineberry
------------------------------------------------------------------------
christineberry's Profile: 1616
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186170

http://www.thecodecage.com/forumz/chat.php

[Simon Lloyd[_10_]]

Our apologies for the recent spam to this thread from our forums, the
user has now been banned and all posts removed.


--
Simon Lloyd

pRegards,/p
pSimon Lloyd/p
pa href="http://www.thecodecage.com/forumz/chat.php"
target="_blank"Excel Chat/a/p
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186170

http://www.thecodecage.com/forumz/chat.php