Access talking to Word

[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

 

[John Vinson]

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?

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.

 

[david epsom dot com dot au]

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?

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)

 

[Albert D. Kallal]

Try downloading my sample word merge.

it is designed to automate the while process from start to finish. Try the
download, and then if you like it..follow the instructions on how to use the
sample in YOUR application.

check out:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[hansford.cornett]

-----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

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.