Question Bookmarks to export data to word

phillsheen

Registered User.
Local time
Today, 13:26
Joined
Jun 12, 2006
Messages
86
Morning!
Can anyone point me in the right direction. Im looking for a web page or help document somewhere to explane how to do bookmarks.
All I need is something that will help me export the name and address of a client from the data base into a letter in word atthe click of a button.
Ive searched on this site and got lots of results but nothing of how to start off doing them from scratch.
Ive never done them before so I need something to help me from the beginning.

Cheers
Phill
 
Simple Software Solutions

Using Bookmarks in Word:

When using book marks to populate data from an Access database you first need to create a document in Word and add the bookmarks in the appropriate places. Give them names that will not be confused with any other type of text that may appear in the document. For example, prefix them with bm, such as, bmLetterDate, bmDearName, bmEtc.

Next you need to create VBA that opens up word blindly and refer to specific bookmarks replacing them with kown Access data.

Search Access on how to automate Word from Access for the syntax.

CodeMaster::cool:
 

Users who are viewing this thread

Back
Top Bottom