Skip,
Thanks for the advice, it is very helpful. I will see what I can do with it. After a much needed vacation, I realize I don't need to use AutoNew. I can any Sub and send arguments as needed. Now if I can only find the time....
Thanks again.
rwgress
A form. The form shows all eligible PNs and checkboxes for each. The user checks which PNs to create bulletins for. My code will create a recordset of pertinent data, then loop through the recordset. For each record, I want to invoke the Word template and pass the data. The template will then...
I am trying to automate creation of a type of bulletin we create. The user selects a part number (or several part numbers) from an Access database and clicks the create button. I want to pass key data from Access to a Word template (through AutoNew).
This existing template already does all that...
This code will work. Add it to AutoNew() (to run when a new document is created from the template) or add it to AutoOpen() to run whenever a document created from the template is opened.
Sub AutoNew()
Dim i As Integer
'You need to add bookmark to the template, called today...
To add an icon to a toolbar to run a macro use this procedure:
1. Click Tools\Customize (or right click on a toolbar and select customize).
2. On the Customize dialog box, select the Commands tab.
3. In the categories window, select Macros.
4. Find the Macro in the Commands window, click and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.