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, 08: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, 09: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, 09: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, 09: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 19th, 2006, 11:45 PM 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, 02: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!





 




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 01:30 PM.


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