Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail merge using Mr & Mrs. John Doe and then Dear John & Carol
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. |
#2
|
|||
|
|||
Mail merge using Mr & Mrs. John Doe and then Dear John & Carol
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "IAMJAS" wrote in message ... 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. |
#3
|
|||
|
|||
Mail merge using Mr & Mrs. John Doe and then Dear John & Carol
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 "IAMJAS" wrote: 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. |
#4
|
|||
|
|||
Mail merge using Mr & Mrs. John Doe and then Dear John & Carol
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "IAMJAS" wrote in message ... 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 "IAMJAS" wrote: 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. |
#5
|
|||
|
|||
Mail merge using Mr & Mrs. John Doe and then Dear John & Carol
Suzanne, Thank you sooooo much. I played around with the fields and finally
got it to work. Thank you for your help. "IAMJAS" wrote: 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. |