Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TraciAnn TraciAnn is offline
external usenet poster
 
Posts: 1
Default Email merge a unique list to each recipient

Word '07

I do an email merge using an Excel data source. The data source lists people,
their contact information and their Team.

I need to create a merged email to each record and include a list of their
team.

So If I have a list:
Column A = Name
Column B = Email
Column C = Team

,Orange Team
,Blue Team
,Orange Team
,Blue Team
,Orange Team
,Blue Team

I need to send an email such as:
=================
Name:

Team assignments have been made. You have been assigned to Team. The other
members of your team and their contact information is:

Name, email
NextRecord
=================


Resulting in:
=================
Tom:

Team assignments have been made. You have been assigned to Orange Team. The
other members of your team and their contact information is:

Harry,
Julie,


=================

What is needed to accomplish this?

--
---
TraciAnn

Message posted via
http://www.officekb.com

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Email merge a unique list to each recipient

Hi TraciAnn,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminolgy depends on the Word version), followed by a
standard email merge. To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

--
Cheers
macropod
[Microsoft MVP - Word]


"TraciAnn" u50702@uwe wrote in message news:965d2e9a7ee8f@uwe...
Word '07

I do an email merge using an Excel data source. The data source lists people,
their contact information and their Team.

I need to create a merged email to each record and include a list of their
team.

So If I have a list:
Column A = Name
Column B = Email
Column C = Team

,Orange Team
,Blue Team
,Orange Team
,Blue Team
,Orange Team
,Blue Team

I need to send an email such as:
=================
Name:

Team assignments have been made. You have been assigned to Team. The other
members of your team and their contact information is:

Name, email
NextRecord
=================


Resulting in:
=================
Tom:

Team assignments have been made. You have been assigned to Orange Team. The
other members of your team and their contact information is:

Harry,
Julie,


=================

What is needed to accomplish this?

--
---
TraciAnn

Message posted via
http://www.officekb.com


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
Can I attach unique files to each recipient within mailmerge MattAkron Mailmerge 1 September 18th 07 01:16 PM
Are you able to add a CC recipient in a mail merge to email? Kathy Mailmerge 1 May 2nd 07 04:25 PM
How do I print a recipient list from a mail merge list in Word? Randog Mailmerge 1 June 20th 06 06:52 PM
Can I add different attachments for each email merge recipient? HeadFish Mailmerge 1 March 29th 06 04:57 AM
Email merge, is it possible to include a CC recipient? Jarod Microsoft Word Help 0 March 8th 06 08:31 PM


All times are GMT +1. The time now is 10:02 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"