Full name

[Sam]

I am struggling with mail merging the full name of my unmarried contacts

 

[Doug Robbins - Word MVP]

In the Outlook Contacts module, click on the Full Name button and you will
get a dialog containing the following fields:

Title:
First:
Middle:
Last:
Suffix:

Or, if you click on the All Fields button and the select Name fields from
the Select from pulldown, you will get access to the following fields:

Assistant's Name
Children
File As
First Name
Full Name
Initials
Job Title
Last Name
Manager's Name
Middle Name
Nickname
Referred By
Spouse/Partner
Suffix
Title

and, in this dialog, if you click on the New button, you can define your own
field.

To get access to all of these fields when using mail merge, you should
initiate the merge from Outlook.

See the "Mailmerge from Outlook" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/mailmerge_from_outlook.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Sam]

Thank you ever-so-much, that is extreamly helpful, I didn't know their were
so many name fields and that you could add your own fields!!

All my mail merges are for couples most with different names and I am not
sure which fields I would input the names so that it looked okay on a letter
e.g. If I put...

Title: Mr & Mrs
First: A & J
Middle:
Last: Smith & Bloggs
Suffix:

it is represented as 'Mr & Mrs A & J Smith & Bloggs', which is obviously not
right!!

I want the address box it say 'Mr A Smith & Mrs J Bloggs' and I want the
Dear... to say 'Dear Mr Smith & Mrs Bloggs' (without the initials)

Do you know how I would put this into the fields so it comes out correct?
Any help is greatly received, I really can't get my head around this, it is
like a rubics cube!!

Thanks

 

[Graham Mayor]

You can't use *parts* of a field in a merge. You need to organise your
contacts list so that you can access fields that contain only the parts of
the data you wish to merge. For example you could use vba to copy parts of
the field to the user configurable fields in Outlook. This is demonstrated
at the end of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm but
could be easily expanded to achieve what you require.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>