J
JetGuy
Hello... I appreciate your comments...
I am needing to create a Word Report with boiler plate paragraphs which are
selected through VBA from Access, based upon user input from an Access form.
I am comfortable storing the paragraphs, creating the Acccess form and
building the output query, but havent spent any time driving Word from
program modules or macros.
The only thing I could come up with was to create a MEMO field in Access
with the selected paragraphs *stacked* into it, then MailMerge that field
into Word as the body of the content. The shortcoming is that automated
formatting would be limited (mostly linefeeds and CRs).
Is there an alternative where I could store all the paragraphs in a Word
template, then selectively turn them on or off programmatically?
Thoughts? I'm open to other approaches...
I am needing to create a Word Report with boiler plate paragraphs which are
selected through VBA from Access, based upon user input from an Access form.
I am comfortable storing the paragraphs, creating the Acccess form and
building the output query, but havent spent any time driving Word from
program modules or macros.
The only thing I could come up with was to create a MEMO field in Access
with the selected paragraphs *stacked* into it, then MailMerge that field
into Word as the body of the content. The shortcoming is that automated
formatting would be limited (mostly linefeeds and CRs).
Is there an alternative where I could store all the paragraphs in a Word
template, then selectively turn them on or off programmatically?
Thoughts? I'm open to other approaches...