The bookmark names in the sample document template get data from Access and VBA as follows:ДЎ TodaysDate: VBA will replace this bookmark with the current date.ДЎ AddressLines: VBA will replace this line with as many lines as necessary to show the recipient's address.ДЎ Salutation: VBA will replace this with the customer's first name or just Sirs if the first name is Null (empty) in the record being printed. I didn't type any of those square brackets. Note that the square brackets around each bookmark's name are visible because the Show Bookmarks option is on. In the example shown in Figure 14-7, I add three bookmarks to the document. You'll need to go through those steps for each item of data that you want VBA to insert later. Press Ctrl+V to paste the typed name as the bookmark name. Choose InsertOBookmark from the Word menu bar.ДҐ. Select (double-click) the name you just typed and then press Ctrl+C to copy it.Д¤. The name cannot contain spaces nor punctuation, and it must start with a letter.ДЈ. Type a short, simple name for the bookmark. Move the cursor to where you want VBA to insert data from Access.Дў. You can insert bookmarks however you wish. In Word's Options dialog box that opens, click the View tab, select Bookmarks, and then click OK. Bookmarks are usually hidden, so before you add any bookmarks to the document, choose ToolsO Options from the Word menu bar.

A bookmark (in Word) is just a placeholder. Wherever you want VBA to insert data from an Access table, create a Word bookmark. You can use any and all Word features - fonts, pictures, tables, WordArt, whatever. Start with any blank Word document and type your form letter (or whatever you wish) as you normally would in Word. The first step to merging data from Access into a Word document is to create a Word document template (DOT file). This is particularly handy when you want to be able to click a button on a form in Access to print one Microsoft Word form letter.

Then, use VBA in Access to replace the bookmarks with data from an Access table. Yet a third approach would be to create a general Word template that contains bookmarks (placeholders) for data to be filled in later. Just learn to use Word's Mail Merge feature, and you're on your way. You can also use the Microsoft Word Mail Merge Wizard to print form letters, envelopes, labels, and catalogs from any Access table or query. The usual method is to just create a report from the Access database window. Bookmarks.There are plenty of ways to print Access data without getting into VBA. Set oRng = oTemplate.AutoTextEntries(strAutotext).Insert _

'strAutotext is the name of the autotext entry 'oTemplate is the template with the autotext - probably ActiveDocument.AttachedTemplate 'strBMName is the name of the bookmark to fill Sub AutoTextToBM(strbmName As String, oTemplate As Template, strAutotext As String) If the bookmark is missing from the document and/or the autotext entry is not in the named template then nothing will be inserted. The most likely place will be the document template so call it from there e.g.ДЄutoTextToBM 'SubAttorneysToAct', ActiveDocument.AttachedTemplate, 'POASattJointlyOrSeverally' The macro will need to know where the autotext entry is stored. Use the following macro to insert your autotext entry.

Vba sub insert text in word document