Access to Word

[bandit]

I have some Access 2000 reports that one of my clients
keeps having me export to Word. I lose formating, like
everyone else. Seems like I am wasting a step even having
the reports in Access but instead should just develop them
once in Word. I know that this will take a Word template
but I am not familiar with them. Do I do something special
besides saving it as a template and putting my data field
name in brackets? I can't seem to find a good walk through
besies Name, Address. Thanks for your help.

Bandit

 

[John Nurick]

Hi Bandit,

There's more involved in merging stuff to Word than just putting the
field names in brackets, but basically it's pretty simple. The links
below should be helpful.

Where things get complicated is if the reports contain anything much in
the way of grouping, sub-reports, and so on. The Word mailmerge system
basically assumes that each record of data is self-contained.

Albert Kallal's sample mailmerge application:
http://www.attcanada.net/~kallal.msn/wordmerge/index.html

Q209976 ACC2000: Using Automation to Run Word Mail Merge from Access
http://support.microsoft.com/?kbid=209976

Q209882 ACC2000: Using Automation to Create a Word 2000 Merge Document
http://support.microsoft.com/?kbid=209882


If Word mailmerge can't do what you need, it's possible to reformat Word
documents under program control using VBA code running in Access. In
that case you might create the report with a simple layout, export it to
Word and have your code tidy up the formatting there.