Results 1 to 2 of 2
2014-12-11, 22:38 #1
- Join Date
- Dec 2014
- Thanked 0 Times in 0 Posts
Mail merge... more than one row for my key... help? thanks
I have a simple question. I know how to use mail merge, but I would like it if I had an excel table for instance:
What I want to do is send a letter automatically to each Client (each client has a specific email), with a link and product name. Problem is each one could contain 1-10 products/links. It won't be the same for each client.
How can I make this happen? I realized that I can't send catalogs via email. What could I do to make this work? Could someone maybe post an example code if this is indeed doable? Also, is there a way to send an email and an attachment via mail merge if I wanted to send the same thing, but the email just as an attachment?
Thanks so much!
2014-12-12, 06:29 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 420 Times in 349 Posts
You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
(it's a Sticky thread at the top of this forum). The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.
For some worked examples, see the attachments to the posts at:
Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB
In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple
As for merging to email with attachments, see: http://word.mvps.org/FAQs/MailMerge/...ttachments.htmCheers,
[MS MVP - Word]