Mail Merge: Using One Excel File with Multiple Sheets

macropod · #6 01-17-2018, 03:25 PM

Quote:

Originally Posted by Townshend

is it possible to get the total of the amounts in the rows?

No.

Quote:

Originally Posted by Townshend

when I go to insert date { DATE \@ "MMMM d, yyyy" } then do Mailings > Finish & Merge > Edit Individual Documents it shows the code at the top instead of the actual Date. Strangely if I do CREATEDDATE that works.

That suggests you're typing the braces instead of inserting them via Ctrl-F9. Two things to note:
1. A plain DATE field will update every time you open the mailmerge output document. The Mailmerge Tips & Tricks 'sticky' thread at the top of this forum has an entry showing how to overcome that.
2. A CREATEDATE field returns the date the mailmerge main document was created, not the date the output document is created (unless you then do a SaveAs and refresh the field display).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge one Excel file into multiple Word Documents	Rushpac	Mail Merge	2	01-27-2017 02:49 PM
Insert slip sheets during a mail merge	mcboats2	Mail Merge	1	12-07-2015 05:01 PM
Mail merge from excel - need to create sheets and create a table	bluenosebex	Mail Merge	5	08-02-2015 05:34 PM
Code for mail merge to reference saved excel file	jtemp57	Word VBA	10	12-16-2013 11:02 PM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM