Mail merge to both sides of postcard sized label formats requires the manipulation of the data source to ensure that the correct data appears on the fronts and backs of the cards, and there is an add-in elsewhere on this site to help with that, but all too frequently manipulation of the data in this manner is not practicable and so I have produced a method to produce both sides of postcards in the formats adopted by the most popular Avery™ post card label types, templates for which are included in the zip file.
Templates are included for Avery™ patterns 3263, 5389 and 8386, which between them cover the range of layouts most commonly adopted, i.e. four labels in two columns, or two labels in one column, with or without a spacer cell. The process only works correctly with these three layouts.
For the process to work, the postcard label document must have two pages, i.e. a page each for the fronts and backs of the postcards.
Begin by setting the document as a 'Letters' type merge document and attach the Excel data source.
Insert the fields and any fixed text in the two (or four) cells that comprise the fronts of the postcards. Use table cell formatting and/or paragraph styles to format the fronts (usually the address) as required. DO NOT use manual formatting as the styles used are re-applied to the tables as the data is inserted and that will remove any manual formatting.
In the remaining two (or four) cells that comprise the backs of the postcards insert the text and fields that make up the backs (usually the message)
The required setup is shown in the following two illustrations.
When happy that the fronts and backs reflect what you require click the button on the Add-ins Tab of the ribbon:
The first time the add-in is run and subsequently if the 'Show disclaimer at start' check box is checked, the usual disclaimer is presented:
Take a few moments to read the disclaimer and then click the button to hide the dialog.
The next dialog is shown below:
Follow the instructions and select the data source. The third field is used to control which field from the data is displayed in the list box of the next screen, illustrated below. The listbox responds almost instantaneously to change of field selection, so you may pick the best column to identify your records.
The letter buttons, alongside and below the list box, are used to limit the displayed data to entries that begin with the initials shown.
All that remains is to click 'Merge Postcard Data' to ensure that the fronts and backs are filled with the corresponding data.
While it is quite possible to manipulate mail merge data to merge the fronts and backs of postcards, the process described on this page creates a complete merge to both sides of a postcard without any additional data manipulation.