Access field to word document

[Unclaimed]

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

 

[RonRepp]

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.

 

[Unclaimed]

This is easily automated, too."

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