#1
|
|||
|
|||
Insert slip sheets during a mail merge
I work in a mail house and am trying to figure a way to insert a slip sheet based on a data field to speed up the production process; if the field is null, continue with the mail merge, if the field is populated, insert the slip sheet then continue with the mail merge. I have attached sample data (spreadsheet) and a slip sheet. |
#2
|
||||
|
||||
It seems to me that all you need for this is to apply an IF field at the end of the mailmerge main document test to your 'endorse' field, coded along the lines of:
{IF{MERGEFIELD endorse}<> "" "SlipSheet"} Where 'SlipSheet' is the actual Slip Sheet content, rather than a separate PDF. Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge help |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge from excel - need to create sheets and create a table | bluenosebex | Mail Merge | 5 | 08-02-2015 05:34 PM |
Insert picture as a header with mail merge (resolution issues) | sanpedro | Mail Merge | 2 | 02-03-2015 09:54 PM |
insert fields mail merge in vba | tariqaleed2 | Word VBA | 6 | 08-21-2014 12:21 AM |
Insert picture background in Word mail merge labels | obasanla | Mail Merge | 6 | 11-26-2012 11:53 PM |
Insert formatted table into word (mail merge) | manojbmsce | Mail Merge | 0 | 09-25-2008 02:25 AM |