Advanced Mail Merge (Word 2007) 1

[Tdharris]

I would like to merge 1 data source to multiple letter types, envelopes, and receipts with one main merge document.

Which is the best way to do it? Using merge fields, macros, code?

I have been unsecessful using a main document that includes the {if{MERGEFIELD Letter Code}="Receipt Less Than $250" "{IncludeText"C:\Documents and Settings\tdharri2\My Documents\Receipt Template2.doc"}"}

and then so on and so forth per document I would like to merge the data source into.

TDH
Business Application Specialist

 

[macropod]

Hi TDH,

You'd get better results if you coded your INCLUDETEXT field correctly - you need double backslashes for the path separators:

{IF{MERGEFIELD Letter Code}="Receipt Less Than $250" {IncludeText"C:\\Documents and Settings\\tdharri2\\My Documents\\Receipt Template2.doc"}}

Also, since you're apparently going to be using documents with different formats and/or margins, each source document will need to start with a 'Next Page' Section break so that it'll have its own page layout in the combined document.

Cheers
Paul Edstein
[MS MVP - Word]

 

[Tdharris]

Thanks Paul, I will fix the brackets right away and also include the Next Page section breaks.

TDH

TDH
Business Application Specialist