A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mail merge one letter to spouses having separate contact entries?



 
 
Thread Tools Display Modes
  #1  
Old December 19th, 2006, 09:32 PM posted to microsoft.public.outlook.contacts
rjwhitehurst
external usenet poster
 
Posts: 3
Default Mail merge one letter to spouses having separate contact entries?

I create separate contact entries for every individual (ie both my Mom and
Dad). This allows me to enter separate birthays, email addresses, cell phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired result is
to have the merge say "John and Jane Doe" and to still have all of the info
on both contacts. I wonder if linking can help with this?

Help!
  #2  
Old December 19th, 2006, 10:01 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Mail merge one letter to spouses having separate contact entries?

If you want to do that type of merge, you shouldn't create separate Contact
Records. You'll notice Outlook Contact Forms are designed to accommodate all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
I create separate contact entries for every individual (ie both my Mom and
Dad). This allows me to enter separate birthays, email addresses, cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired result
is
to have the merge say "John and Jane Doe" and to still have all of the
info
on both contacts. I wonder if linking can help with this?

Help!


  #3  
Old December 19th, 2006, 10:18 PM posted to microsoft.public.outlook.contacts
rjwhitehurst
external usenet poster
 
Posts: 3
Default Mail merge one letter to spouses having separate contact entri

Yes, thanks. However, the form doesn't accomodate email addresses, wrok,
cell, and fax numbers for each of those individuals. Thus, I must create
separate records for each.

Any other thoughts would be greatly appreciated.



"Russ Valentine [MVP-Outlook]" wrote:

If you want to do that type of merge, you shouldn't create separate Contact
Records. You'll notice Outlook Contact Forms are designed to accommodate all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
I create separate contact entries for every individual (ie both my Mom and
Dad). This allows me to enter separate birthays, email addresses, cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired result
is
to have the merge say "John and Jane Doe" and to still have all of the
info
on both contacts. I wonder if linking can help with this?

Help!


  #4  
Old December 19th, 2006, 10:27 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Mail merge one letter to spouses having separate contact entri

No other ideas. Obviously, you cannot construct a merge that uses data from
two separate Contacts in the same merge field layout.

--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
Yes, thanks. However, the form doesn't accomodate email addresses, wrok,
cell, and fax numbers for each of those individuals. Thus, I must create
separate records for each.

Any other thoughts would be greatly appreciated.



"Russ Valentine [MVP-Outlook]" wrote:

If you want to do that type of merge, you shouldn't create separate
Contact
Records. You'll notice Outlook Contact Forms are designed to accommodate
all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
I create separate contact entries for every individual (ie both my Mom
and
Dad). This allows me to enter separate birthays, email addresses, cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired
result
is
to have the merge say "John and Jane Doe" and to still have all of the
info
on both contacts. I wonder if linking can help with this?

Help!



  #5  
Old December 20th, 2006, 12:45 AM posted to microsoft.public.outlook.contacts
Judy Gleeson \(MVP Outlook\)
external usenet poster
 
Posts: 1,689
Default Mail merge one letter to spouses having separate contact entri

This idea may work -

add the spouse's name to the men's Contacts forms, then mailmerge and use
the fields this way:

Hi First and Spouse name

You'll need to select only the guys when you merge. Leave out last name as
they may have different ones!

I hope this helps you at least a little bit!

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
No other ideas. Obviously, you cannot construct a merge that uses data
from two separate Contacts in the same merge field layout.

--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
Yes, thanks. However, the form doesn't accomodate email addresses, wrok,
cell, and fax numbers for each of those individuals. Thus, I must create
separate records for each.

Any other thoughts would be greatly appreciated.



"Russ Valentine [MVP-Outlook]" wrote:

If you want to do that type of merge, you shouldn't create separate
Contact
Records. You'll notice Outlook Contact Forms are designed to accommodate
all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
I create separate contact entries for every individual (ie both my Mom
and
Dad). This allows me to enter separate birthays, email addresses,
cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired
result
is
to have the merge say "John and Jane Doe" and to still have all of the
info
on both contacts. I wonder if linking can help with this?

Help!




  #6  
Old December 20th, 2006, 03:21 AM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Mail merge one letter to spouses having separate contact entri

That was the idea OP already dismissed: including both names on the same
form.

--
Russ Valentine
[MVP-Outlook]
"Judy Gleeson (MVP Outlook)" wrote in message
...
This idea may work -

add the spouse's name to the men's Contacts forms, then mailmerge and use
the fields this way:

Hi First and Spouse name

You'll need to select only the guys when you merge. Leave out last name
as they may have different ones!

I hope this helps you at least a little bit!

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
No other ideas. Obviously, you cannot construct a merge that uses data
from two separate Contacts in the same merge field layout.

--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
Yes, thanks. However, the form doesn't accomodate email addresses,
wrok,
cell, and fax numbers for each of those individuals. Thus, I must
create
separate records for each.

Any other thoughts would be greatly appreciated.



"Russ Valentine [MVP-Outlook]" wrote:

If you want to do that type of merge, you shouldn't create separate
Contact
Records. You'll notice Outlook Contact Forms are designed to
accommodate all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in
message
...
I create separate contact entries for every individual (ie both my Mom
and
Dad). This allows me to enter separate birthays, email addresses,
cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired
result
is
to have the merge say "John and Jane Doe" and to still have all of
the
info
on both contacts. I wonder if linking can help with this?

Help!





  #7  
Old December 20th, 2006, 07:05 AM posted to microsoft.public.outlook.contacts
Judy Gleeson \(MVP Outlook\)
external usenet poster
 
Posts: 1,689
Default Mail merge one letter to spouses having separate contact entri

Yeh I know - but it's the only part solution I could see for the OP! He can
still have 2 Contacts, but just use one of them for the merge.

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
That was the idea OP already dismissed: including both names on the same
form.

--
Russ Valentine
[MVP-Outlook]
"Judy Gleeson (MVP Outlook)" wrote in message
...
This idea may work -

add the spouse's name to the men's Contacts forms, then mailmerge and use
the fields this way:

Hi First and Spouse name

You'll need to select only the guys when you merge. Leave out last name
as they may have different ones!

I hope this helps you at least a little bit!

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
No other ideas. Obviously, you cannot construct a merge that uses data
from two separate Contacts in the same merge field layout.

--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
Yes, thanks. However, the form doesn't accomodate email addresses,
wrok,
cell, and fax numbers for each of those individuals. Thus, I must
create
separate records for each.

Any other thoughts would be greatly appreciated.



"Russ Valentine [MVP-Outlook]" wrote:

If you want to do that type of merge, you shouldn't create separate
Contact
Records. You'll notice Outlook Contact Forms are designed to
accommodate all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in
message
...
I create separate contact entries for every individual (ie both my
Mom and
Dad). This allows me to enter separate birthays, email addresses,
cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired
result
is
to have the merge say "John and Jane Doe" and to still have all of
the
info
on both contacts. I wonder if linking can help with this?

Help!







  #8  
Old December 20th, 2006, 03:26 PM posted to microsoft.public.outlook.contacts
rjwhitehurst
external usenet poster
 
Posts: 3
Default Mail merge one letter to spouses having separate contact entri

Thanks, Judy and Russ. Just adding the spouse names, but keeping the spuses
own contact record will address this challange. BUT - it adds another layer
to a process that I believe Outlook should better streamline.

I cannot be alone with this problem, can I? Having individual records is
key for those of us who sync our pc and smartphone or, actually, just to
anyone who emails with outlook.

Jody

"Judy Gleeson (MVP Outlook)" wrote:

Yeh I know - but it's the only part solution I could see for the OP! He can
still have 2 Contacts, but just use one of them for the merge.

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
That was the idea OP already dismissed: including both names on the same
form.

--
Russ Valentine
[MVP-Outlook]
"Judy Gleeson (MVP Outlook)" wrote in message
...
This idea may work -

add the spouse's name to the men's Contacts forms, then mailmerge and use
the fields this way:

Hi First and Spouse name

You'll need to select only the guys when you merge. Leave out last name
as they may have different ones!

I hope this helps you at least a little bit!

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
No other ideas. Obviously, you cannot construct a merge that uses data
from two separate Contacts in the same merge field layout.

--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
Yes, thanks. However, the form doesn't accomodate email addresses,
wrok,
cell, and fax numbers for each of those individuals. Thus, I must
create
separate records for each.

Any other thoughts would be greatly appreciated.



"Russ Valentine [MVP-Outlook]" wrote:

If you want to do that type of merge, you shouldn't create separate
Contact
Records. You'll notice Outlook Contact Forms are designed to
accommodate all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in
message
...
I create separate contact entries for every individual (ie both my
Mom and
Dad). This allows me to enter separate birthays, email addresses,
cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired
result
is
to have the merge say "John and Jane Doe" and to still have all of
the
info
on both contacts. I wonder if linking can help with this?

Help!








  #9  
Old December 20th, 2006, 11:15 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Mail merge one letter to spouses having separate contact entri

So far, you're pretty much alone. I've seen no one request the ability to
merge two different Contact Records into a single merge field layout. One of
the hardest things to do when setting up your Contacts is to anticipate the
consequences of how you organize them. Typically, users who expect to use
mail merges heavily will create at least one "master" Contact Record for a
family that will include all snail mail and name elements needed for a
merge, then create a second record to keep track of the various electronic
addresses for each family member.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in message
...
Thanks, Judy and Russ. Just adding the spouse names, but keeping the
spuses
own contact record will address this challange. BUT - it adds another
layer
to a process that I believe Outlook should better streamline.

I cannot be alone with this problem, can I? Having individual records is
key for those of us who sync our pc and smartphone or, actually, just to
anyone who emails with outlook.

Jody

"Judy Gleeson (MVP Outlook)" wrote:

Yeh I know - but it's the only part solution I could see for the OP! He
can
still have 2 Contacts, but just use one of them for the merge.

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
That was the idea OP already dismissed: including both names on the
same
form.

--
Russ Valentine
[MVP-Outlook]
"Judy Gleeson (MVP Outlook)" wrote in
message
...
This idea may work -

add the spouse's name to the men's Contacts forms, then mailmerge and
use
the fields this way:

Hi First and Spouse name

You'll need to select only the guys when you merge. Leave out last
name
as they may have different ones!

I hope this helps you at least a little bit!

Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

"I not only use all the brains I have, but all I can borrow." (Woodrow
Wilson)
"Russ Valentine [MVP-Outlook]" wrote in message
...
No other ideas. Obviously, you cannot construct a merge that uses
data
from two separate Contacts in the same merge field layout.

--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in
message
...
Yes, thanks. However, the form doesn't accomodate email addresses,
wrok,
cell, and fax numbers for each of those individuals. Thus, I must
create
separate records for each.

Any other thoughts would be greatly appreciated.



"Russ Valentine [MVP-Outlook]" wrote:

If you want to do that type of merge, you shouldn't create separate
Contact
Records. You'll notice Outlook Contact Forms are designed to
accommodate all
family members in a single record.
--
Russ Valentine
[MVP-Outlook]
"rjwhitehurst" wrote in
message
...
I create separate contact entries for every individual (ie both my
Mom and
Dad). This allows me to enter separate birthays, email
addresses,
cell
phone
and work numbers, etc.

BUT - when I perform a mail merge, I get TWO letters. My desired
result
is
to have the merge say "John and Jane Doe" and to still have all
of
the
info
on both contacts. I wonder if linking can help with this?

Help!









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.