[Sam]

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

[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" wrote in message
...
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

[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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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

[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_lab...th_word_xp.htm but
could be easily expanded to achieve what you require.

--

Graham Mayor - Word MVP

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



Sam wrote:
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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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