Contact Mailmerge with both home/business address

  • Thread starter Thread starter KathrynBassett
  • Start date Start date
K

KathrynBassett

So far, I'm getting how to make mailing labels from Outlook. First, I
make a contact view with just the category I want (for instance
Christmas), then choosing the fields.

I end up with this result:
«Full_Name»
«Business_Address»
«Home_Address»

I have the eliminate line if empty option, and it all works ok EXCEPT
when I have BOTH a business and home address. Then it prints both
addresses like:

John Doe
PO Box 12345
Salt Lake City, UT 84165
248 E Any St
Salt Lake City, UT 84115

I'm not a Word person, so I don't know what code to add to my above
result to make it choose whichever address is the primary address -
iow, the one with the checkmark in "this is the mailing address"

I also get people who have no address at all, so I guess I need to put
in some sort of code to eliminate those people as well.

What do I need to add (code-wise) to this to get it to work the way I
want?
 
How about you use the function that Outlook has there for you? In the
Contact cards you can select Use this address as the Mailing address. Can
that help you?? There must be a field that uses Mailing address for your
situation.

--
Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia


see what Outlook training can do to improve productivity:
www.acorntraining.com.au/pdfdocs/ProductivITwithOutlook.pps

www.acorntraining.com.au/productivit.htm
So far, I'm getting how to make mailing labels from Outlook. First, I
make a contact view with just the category I want (for instance
Christmas), then choosing the fields.

I end up with this result:
«Full_Name»
«Business_Address»
«Home_Address»

I have the eliminate line if empty option, and it all works ok EXCEPT
when I have BOTH a business and home address. Then it prints both
addresses like:

John Doe
PO Box 12345
Salt Lake City, UT 84165
248 E Any St
Salt Lake City, UT 84115

I'm not a Word person, so I don't know what code to add to my above
result to make it choose whichever address is the primary address -
iow, the one with the checkmark in "this is the mailing address"

I also get people who have no address at all, so I guess I need to put
in some sort of code to eliminate those people as well.

What do I need to add (code-wise) to this to get it to work the way I
want?
 
That's the problem. I DO have the "Use this address as the Mailing
address" in use. The problem is that for the merging, there doesn't
seem to be a way to say "use the address that is set as the mailing
address" You have to choose home or business or other.
 
Indeed. When you are merging to Outlook, you would be far better served by
starting your merge form Outlook and using only Outlook fields to parse your
address elements yourself. Using a derived address field is not recommended.
 
I just tested it with 3 Contacts. 2 set to mail to their business address,
1 to home address.

Shut Word.
Select the Contacts.
Tools | Mailmerge (then select whether you want to use a new or existing
document)
Insert Merge Fields (NOT Word Fields) once Outlook fires up Word.
Find the field I mentioned in my previous post - Mailing Address and use
it. It will use the one that you set. This can be either Business or Home.
It will NOT put them both in.

«Mailing_Address»



Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia



see what Outlook training can do to improve productivity:
www.acorntraining.com.au/pdfdocs/ProductivITwithOutlook.pps

www.acorntraining.com.au/productivit.htm
Russ Valentine said:
Indeed. When you are merging to Outlook, you would be far better served by
starting your merge form Outlook and using only Outlook fields to parse your
address elements yourself. Using a derived address field is not recommended.
--
Russ Valentine
[MVP-Outlook]
KathrynBassett said:
That's the problem. I DO have the "Use this address as the Mailing
address" in use. The problem is that for the merging, there doesn't
seem to be a way to say "use the address that is set as the mailing
address" You have to choose home or business or other.
Click to expand...
Click to expand...
 
Should work in current versions, but it won't in all. This would never work
in Outlook 2000 IMO, for example.
--
Russ Valentine
[MVP-Outlook]
Judy Gleeson MVP - Outlook said:
I just tested it with 3 Contacts. 2 set to mail to their business address,
1 to home address.

Shut Word.
Select the Contacts.
Tools | Mailmerge (then select whether you want to use a new or existing
document)
Insert Merge Fields (NOT Word Fields) once Outlook fires up Word.
Find the field I mentioned in my previous post - Mailing Address and use
it. It will use the one that you set. This can be either Business or
Home.
It will NOT put them both in.

«Mailing_Address»



Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia



see what Outlook training can do to improve productivity:
www.acorntraining.com.au/pdfdocs/ProductivITwithOutlook.pps

www.acorntraining.com.au/productivit.htm
Russ Valentine said:
Indeed. When you are merging to Outlook, you would be far better served
by
starting your merge form Outlook and using only Outlook fields to parse your
address elements yourself. Using a derived address field is not recommended.
--
Russ Valentine
[MVP-Outlook]
KathrynBassett said:
That's the problem. I DO have the "Use this address as the Mailing
address" in use. The problem is that for the merging, there doesn't
seem to be a way to say "use the address that is set as the mailing
address" You have to choose home or business or other.
Click to expand...
Click to expand...
Click to expand...
 
Oh, duh! I had not seen the «Mailing_Address» one. Actually, even if
I had noticed it, I probably wouldn't have put 2+2 together to realize
what it meant. That worked beautifully.

Now only one question left. What do I put in to keep it from making
lname only abels for people for whom there is NO mailing address?
 
PS. Having no address checked as "this is the mailing address" does not
eliminate the name only labels.
 
Back
Top