Using Macros and Letters

Before you can begin using macros in eSite letters, you must define the AMSIPostMergeModule and AMSIPostMergeMacro. We provide basic instruction on how to complete this task. Once completed, you may begin recording macros for using with eSite letter documents. For more information about macros, and how they are used in Word, open any Word document and select Help from the product toolbar.

For the purposes of this instruction, we will work with an eSite letter document named GuestL

Open an eSite letter document to work with. For instance, open GuestL.
Select Tools—Macro—Visual Basic Editor from the Word toolbar. The Visual Basic Editor opens. In the project pane you will see the project with the same name as the eSite letter. For instance, you will see a project named GuestL.

Note

In this project, you will use Modules.

Locate the Insert menu and select Module.
Name the new module, AMSIPostMergeModule.
Within that module, create a sub-routine called AMSIPostMergeMacro.
Save and close the Visual Basic Editor.

For the purposes of this instruction, we will record a macro named Signature.

Open an eSite letter document to work with. For instance, open GuestL.
Select Tools—Macro—Record New Macro from the Word toolbar to record a new macro.
Name the macro, Signature and click OK.
Select Ctrl + End to move to the end of the document.
Type text you want to record for the signature.
Click the Stop button on the macro recorder controls dialog box.
Select Tools—Macro—Visual Basic Editor from the Word toolbar. This Visual Basic Editor opens.
Copy the Signature sub-routine into the AMSIPostMergeMacro.
Make any additional changes to the sub-routine as needed. For instance, add the current date and time if desired.
Save your entry in the Visual Basic Editor.
Save the document.
Close the document.

Using Macros in Letters