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:
http://www.acorntraining.com.au/pdfd...ithOutlook.pps

www.acorntraining.com.au/productivit.htm
"KathrynBassett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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.
--
Russ Valentine
[MVP-Outlook]
"KathrynBassett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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:
http://www.acorntraining.com.au/pdfd...ithOutlook.pps

www.acorntraining.com.au/productivit.htm
"Russ Valentine [MVP-Outlook]" <(E-Mail Removed)> wrote in message
news:Ow#(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.
> >
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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:
> http://www.acorntraining.com.au/pdfd...ithOutlook.pps
>
> www.acorntraining.com.au/productivit.htm
> "Russ Valentine [MVP-Outlook]" <(E-Mail Removed)> wrote in message
> news:Ow#(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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.
>> >
>>
>>
>
>

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.

have now made a tutorial page
http://www.bassett.net/storage/merge...rgeproblem.htm