Full name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 30 Mar 2008 12:37 GMT

>I am struggling with mail merging the full name of my unmarried contacts
> through to a word document. I want to create a formal letter as
> follows...
>
> "Mr A Smith & Mrs J Bloggs
> 1 Nowhere Place
> Nowhere
> NN9 9AA
>
> 28th March 2008
>
> Dear Mr Smith & Mrs Bloggs"
>
> But I am unsure how to complete the full name box in outlook contacts so
> that for unmarried couples I can have their initlals in the address box
> and
> no initials after Dear....
>
> It needs to be broken down like...
>
> Title:
> First:
> Middle:
> Last:
> Suffix:
>
> Hope that makes sense, any Ideas?
>
> Thankyou in advance
> Sam

Reply to this Message

Doug Robbins - Word MVP - 30 Mar 2008 20:26 GMT

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

Signature

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

> >I am struggling with mail merging the full name of my unmarried contacts
>> through to a word document. I want to create a formal letter as
[quoted text clipped - 26 lines]
>> Thankyou in advance
>> Sam

Reply to this Message

Sam - 31 Mar 2008 14:31 GMT

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

> In the Outlook Contacts module, click on the Full Name button and you will
> get a dialog containing the following fields:
[quoted text clipped - 65 lines]
> >> Thankyou in advance
> >> Sam

Reply to this Message

Graham Mayor - 31 Mar 2008 15:14 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 100 lines]
>>>> Thankyou in advance
>>>> Sam

Reply to this Message

Rate this thread: