Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro to add data to merged document
I work in an area of a company that reviews accounts and recommends
their closure, if necessary. The form which must be submitted for each account has several standard fields (from a database) but has four options in the recommendation section. Is there a way to write a macro so that whatever the value of the "category" field (six options) would determine what is printed in the recommendation section. Many thanks |
#2
|
|||
|
|||
You don't need a macro but a field.
Create six texts that correspond with your six recommendations and name them the same as the content of the appropriate category field either as autotext entries, documents or bookmarked sections of a document. You can then insert the content using either a autotext field or an includetext field thus: {Autotext "{Mergefield Category}"} or {Includetext "c:\\pathname\\{Mergefield Catergory}.doc" } or {Includetext "c:\\pathname\\docname.doc {Mergefield Category}} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org FJB wrote: I work in an area of a company that reviews accounts and recommends their closure, if necessary. The form which must be submitted for each account has several standard fields (from a database) but has four options in the recommendation section. Is there a way to write a macro so that whatever the value of the "category" field (six options) would determine what is printed in the recommendation section. Many thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro preventing document to be opened | Microsoft Word Help | |||
How do keep blank lines when merging a document with the data and. | Mailmerge | |||
How do I create a macro to data sort in a table within a protecte. | Tables | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
faxing from word 2003 mail merge | Mailmerge |