Exporting data into Word from an Access Form

  • Thread starter Thread starter Fred's
  • Start date Start date
F

Fred's

Hi Folks,


If these a way to export data with a command button on a form into
Word?

Any help on this will be very appreciated,

Thanks to all,
Fred's
 
Fred

"into Word", ... do you mean like a Word merge document?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Fred

"into Word", ... do you mean like a Word merge document?

Regards

Jeff Boyce
Microsoft Office/Access MVP









- Show quoted text -
Click to expand...

This is my needs:

I have a report which is in Access, the report bound to a query, which
needs to be exported in word.

I want to add a command button on my form and when I press the button,
the access report will be exported in WORD.

Thank you,
Fred's
 
Most reports don't transfer very successfully directly to a Word document.
Too much of the formatting is damaged in the process. The options I've used
are:
a) Word mail merge, so you pass the data to Word but use Word for the
formatting. This is pretty straightforward.
b) Run Word from Access, building an arbitrarily complex document. This gets
you anything you want, but it's a lot of work.
c) Create a pdf from the report, which usually preserves every detail of the
report format. This is also pretty straightforward, but it's only useful if
the recipient doesn't need to do any editing.
Paul Shapiro
 
Back
Top