Mail merge into different coloumns

macropod · #4 07-13-2014, 07:04 AM

Try the attached. Simply save both files to the same folder. Note the extra column in the worksheet to calculate the expiry dates.

Of course, you may not want the shading I've used for the tables. The output format, including the shading, is controlled by field switches. To see the field codes and switches, press Alt-F9. For an overview of what they do and how they're used, see: http://office.microsoft.com/en-us/wo...010260104.aspx. That link refers to a 'Table AutoFormat dialog box', which you can access via Insert|Quick Parts|Field>DataBase.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge is Deleting objects in my header and footer during the merge	bgranzow	Mail Merge	9	06-05-2015 05:03 AM
Mail merge how to link mail merge field value to a column heading	dsummers	Mail Merge	1	05-08-2014 02:59 PM
Mail Merge Duplication of address on merge	RICKY	Mail Merge	1	09-26-2012 03:14 PM
Conditional merge fields in mail merge	Aude	Mail Merge	1	01-06-2012 07:38 PM
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM