Manipulating a Word document from Access 2007

[Bobby]

Hi,
I am using Office 2007.

I need to be able to open a Word document from Access and insert a
customer name and address depending on the record selected.

I guess I could do it using Word VBA, but I really want Access to
control what goes into the document.

Can anybody recommend the best way to do this.

Thanks for any help,

Colin

[Albert D. Kallal]

Re: Manipulating a Word document from Access 2007


I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the follwoing page

http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html

Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKa llal@msn.com

[Bobby]

Re: Manipulating a Word document from Access 2007


Hi Albert
This is excellent. I'm just having a look at it now, but it looks
exactly what I was after,

Thanks a lot

Colin


On 14 Oct, 22:19, "Albert D. Kallal" <PleaseNOOOsPAM mkal...@msn.com >
wrote:

I have a nice working sample that does a merge of the current record to
word.
>
The sample I have can be found here:http://www.members.shaw.ca/AlbertKal.../msaccess.html
>
What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....
>
Thus, each time you build a new form, you can word merge enable it with
great ease.
>
Make sure you read the instructions from above, and you should eventually
get to the follwoing pagehttp://www.members.sha w.ca/AlbertKallal/wordmerge/page2.html
>
Note that the merge can also use a query, and thus you don't have to merge
just "one" record..
>
After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).
>
Give the above a try.
>
--
Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKa l...@msn.com

[Tony Toews [MVP]]

Re: Manipulating a Word document from Access 2007

Bobby <bobby2@blueyon der.co.ukwrote:

>This is excellent. I'm just having a look at it now, but it looks
>exactly what I was after,

And it works very well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/