Access talking to Word

  • Thread starter Thread starter Martina
  • Start date Start date
M

Martina

Dear Experts,

Is is possible for Access to export a record/records to
Word where a preformulated form letter has been created in
order to do the whole mail merge thing? Does this require
VBA programming?

regards

Martina
 
Dear Experts,

Is is possible for Access to export a record/records to
Word where a preformulated form letter has been created in
order to do the whole mail merge thing?
Yes.

Does this require
VBA programming?
Click to expand...

Yes.

You can "pull" the data into a Word Mail-Merge document by opening the
document master in Word, and specifying an Access Query as the data
source.

Or, you can "push" the data into a document from Access. In this case
it may be simpler to create a document template (.DOT file) in Word,
with named "bookmarks" where you want the data put; use Office
Automation to open a Word instance and loop through a recordset
pushing the data into the document. The code I (am just learning how
to!) use is copyrighted, in the Access Developer's Handbook, but it
seems pretty straightforward.
 
Is possible for Access to export a record/records to
Word where a preformulated form letter has been created in
order to do the whole mail merge thing?
Yes

Does this require VBA programming?
Click to expand...

No.

Open a table or query and select some records, or just
select a table or query from the database view.

Right-Click and select Export from the menu.

Export as XLS or Word Merge.

Then use Word Mail-Merge as normal from Word.


You can also use the Access Database as the Data Source,
but if, like most Word users, you normally do your
mail-merge from Excel, there is no reason to change.

(david)
 
-----Original Message-----
Dear Experts,

Is is possible for Access to export a record/records to
Word where a preformulated form letter has been created in
order to do the whole mail merge thing? Does this require
VBA programming?

regards

Martina
.
Then again I find it easier in most cases to build the
Click to expand...
template as a report in ACCESS and do the mail merge right
there in ACCESS. Very fast and reliable....if you need
more info contact me via email however I will post the
reply back here for the group to benefit.
 
Back
Top