I have a letterhead template with an AutoNew macro which displays a list of names from which the users chooses. The list is actually generated from an Excel file and the excel file contains full name, closing, and email address. This information is used to customize/personalize letterheads.
A couple of my users complain because they do letters for only one or two people so they do not want to constantly choose a name from the list. They want a single button to click to do the customized letterhead. As the manager of the templates, I only want the one letterhead template.
I am trying to write a macro in which I can code the name I want, call my letterhead template and pass the name to the AutoNew macro and not display the dialogue box. I have:
Public strName As String
strName = "James E. Fortin"
Documents.Add Template:= _
Stepping through the code, when I am in the code in the letterhead template, strName is empty. Shouldn't the public declaration let this go to the other module? What am I missing?