Mail merge using Mr & Mrs. John Doe and then Dear John & Carol

[Guest]

I am trying to do a mial merge from Outlook to Word. Microsoft Office is
what I am using.

I want the letter to look like this.

Mr. & Mrs. John Doe
123 Anywhere Street
Anywhere, NJ 08080

Dear John and Carol:

I am having difficulty getting the John and Carol part of it into the merge.

Any help muchly appreciated.

 

[Suzanne S. Barnhill]

You must have fields in your data source that provide this information. In
the example you cite, in addition to the First Name, Last Name, Title,
Address1, City, State, ZIP, etc., you would also have to have a Salutation
field that provides the first names. You then insert the merge fields as
required.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Dear Suzanne:
thank you for your response. I can get everything but I cannot get the "and
Carol" part into the salutation. This is what has me stumped. There is
something I am not doing right.
IAMJAS

 

[Suzanne S. Barnhill]

You must have a Salutation data field that contains the text "John and
Carol." Alternatively, if you already have data fields that contain both
names (and if every salutation will contain two names) you can insert merge
fields for the two first-name data fields, separated by "and."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Suzanne, Thank you sooooo much. I played around with the fields and finally
got it to work. Thank you for your help.