How do I Export Access Form text to word form type document?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to create a form in Access but want to export that data to a
word document that can be e-mailed as required. I am wondering if a macro or
VBA code would be better and if using VBA code what kind of examples may be
around to use? I am just learning Access and VBA so beginner user.
 
Try This: Create the form the way you want and save it. Then Open the form
in design mode and "Save As" a report. Open the report in design mode and
clean it up the way you want.

Often I make sure I have the key or a particular reference field on the
form. Then I create a query to mirror the information on the form. In the
reference field you use on the form and in the query, under the criteria in
the query, make this equal the same reference as the open record on the form.

Add a command button to your form that calls your report as a snapshot and
then send it which attaches it to an email message. These steps can be
automated also with a little code.
 
Back
Top