#1
|
|||
|
|||
Mail Merge Letter
Hi everyone,
I'm trying to do a merge letter with an excel workbook as the source. When I've done this in the past, I've used it as a tool to produce multiple letters at a single time. However, in this case, I'm trying to produce only a single letter at a time, multiple times. Can I name a range (B2:AH2, for instance) to produce a single letter? Thanks, Chris |
#2
|
||||
|
||||
Hi Chris,
You can use filtering in the mailmerge main document to exclude the records that are not of interest - or you could use a SKIPIF field coded along the lines of: {SKIPIF {MERGEREC} <> {FILLIN "Merge Which Record #" \d 1 \o} } Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Sounds great.
Thanks Paul! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting an Email Address with hyperlink into a Mail Merge Letter | AClaborn | Mail Merge | 3 | 10-15-2013 04:02 PM |
Urgent Supprt Need to Create Mail Merge letter | risnasmhd | Mail Merge | 1 | 09-29-2013 08:11 PM |
Split multi-page mail merge document, then name file from letter info. | BriMan83 | Mail Merge | 1 | 04-24-2013 11:35 PM |
Merge excel info into word letter. | curatorfm | Mail Merge | 1 | 03-20-2011 04:26 AM |
Merge to New Document - saved letter continues to ask for SQL source | Brandi | Mail Merge | 2 | 06-16-2010 08:08 AM |