View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Creating a rule for duplicate entry in excell for a mail merge

See fellow MVP Macropod's "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 as you must get the mail merge main document set up exactly as
required.


--
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
"mwhobg" wrote in message
...
OK... I don't know exactly how to work this question, so Let me outline
what
I am trying to do .

I have an email message that I want to send to multiple recipients that
includes invoice data from an excel spreadsheet.

So here is the problem I am having. Within the spreadsheet there are
multiple entries in the file for that need to be sent to one recipient.
But
as it stands now I am only able to list one entry per email.

Basically I want to be able to set up a rule/formula/whatever it is to
look
at the excel file and determine if a contact is listed on multiple
entries,
if it is then I want to pull all of those entries into one email and then
send it out, instead of sending out multiple emails to the same contact
with
each individual line item where they are referenced.

Is that possible?

did any of that make sense?