If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. You can download the sample file related to this article from the link below: These name formats will only work correctly if each field has been defined in the Recipient List and has been matched correctly in the Match Fields window.Īt the end of the greeting line you can specify to display a Comma or Colon character:

First Name + Spouse/Partner First Name + Last Name.

Prefix + First Name + Last Name + Suffix.

Using the second drop down list you can determine the format to display the name:Īs you can see there are different formats: Using the first drop down list you can determine what to display before the name:

Using the drop down lists available on the Insert Greeting Line window you can choose how to display the greeting line. This can be done by using the Match Fields window:įor more information about working with the Match Fields window please see the link below: While it may be obvious for you what data each column is displaying but it might not be the same for word. Word might not interpret correctly which column is storing what data. Therefore you might need to manually define (for word) what data each column is storing. The fourth column is storing the recipient’s Address.The third column is storing the recipient’s Title.The second column is storing the First Name of the recipients.This first column is storing the Last Name of the recipients.For example consider the recipient list below:

Each column was associated with a certain type of data. If you remember from that article when we wanted to define a recipient list, we would define columns. So where is this data going to come from? This data will come from the Recipient List previously created. What do you expect to see in a greeting line?

Email merge from word online