Results 1 to 2 of 2
2014-06-20, 05:21 #1
- Join Date
- Jun 2014
- Thanked 0 Times in 0 Posts
Mail Merge Multiple Rows Per Doc - THEN email.
Dont know if what i'm attempting to do is possible. Im sure it must be. I am very stuck though! Tried for hours.
Ultimatey, I am trying to mailmerge a spreadsheet relating to invoices. there are multiple rows for each company, however each row is a unique Invoice Number.
Instead of email mail merging normally, I want just one mail merge made for each company, where it lists the invoices there, rather than a whole new document per row. Otherwise I'd send one company 50 emails!
I have attached an example spreadhseet - and I have attached a screenshot of the word document Im working on.
Dont ask me where I got that code at the top of the word document - ive copied and pasted from somewhere - it might as well be written in italian. Im trying to match the mergefields with what I think it's trying to denote. Yet, I cant make an If then else mergefield?
Anyway - could you help?
Is it possible to do this sort of mail merge, then use the email column to designate where to send the finished merged product?
2014-06-21, 00:02 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 439 Times in 362 Posts
Cross-posted at: http://www.msofficeforums.com/mail-m...ail-merge.html
For cross-posting etiquette, please read FORUM RULE 14: http://windowssecrets.com/forums/faq...n#crosspostingCheers,
[MS MVP - Word]