Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access field to word document

Status
Not open for further replies.

Unclaimed

Technical User
Apr 26, 2007
2
US
I am attempting to send the current record in Access to a Word document via a cmd button. I used bookmarks in Word but learned the hard way that Word does not allow duplicate named bookmarks in the same document. I have a cover letter that repeats [firstName] [LastName] etc... through out the document and will only populate one of the duplicated bookmarks. Is there a way around this because otherwise it works simply. Any suggestions are well appreciated. I am learning VBA and SQL but not great at it yet.

Robert

 
Setup a Mail-merge doc in Word and point it to your DB to add field names.

Then, whenever you open the doc, it will prompt you on where to start.

This is easily automated, too.

I hope this helps.


Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.
 
This is easily automated, too."

The automation part is what I am working on, thanks for the input.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top