Mail Merging Word by excel sheet

macropod · #1 06-05-2015, 05:40 PM

Quote:

Originally Posted by Mandy11

If you have a lot of data, I would suggest you create a quick pivot table and sum the invoices. Then copy and paste/special the data so you can use it for the mail merge.

This adds a quite unnecessary manual step that is not conducive to meeting the OP's needs.

As an alternative to installing a many-to-one utility, you can also 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:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
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:
https://www.msofficeforums.com/mail-...html#post23345

https://www.msofficeforums.com/mail-...html#post30327
http://windowssecrets.com/forums/sho...l=1#post928391

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loss of formulae values when mail merging excel to word	MellowMel	Mail Merge	6	05-09-2014 09:08 AM
Mail Merging forumlas with Word 2010	aaiden	Mail Merge	2	09-30-2013 03:48 PM
How to Copy data from Outlook mail and Paste it in a Excel sheet?	padhu1989	Outlook	0	09-11-2012 04:07 AM
Mail merging and pulling varying data from Excel	shannag1881	Mail Merge	0	10-05-2009 08:51 AM
HELP! Merging Excel to Word	peevenjo	Mail Merge	0	07-06-2007 03:24 PM