Mail Merge Company Name with Business Address Only

[Guest]

The mailing addresses in my contacts are a mix of home and business
addresses. I want to do a mail merge that includes the company name only when
the business address is the mailing address. Using Outllook 2003 SP2. Is this
easy and I've just missed it? Doable with coding or 3rd party tool? Thanks in
advance!

 

[Russ Valentine [MVP-Outlook]]

Not easy to do. This is a Word question, not an Outlook question. Post there
on instructions for how to construct a merge using fields that will be
populated conditionally, suppress blank lines if a field is empty, etc.

 

[Guest]

I'm sorry, I must be missing something, or perhaps I didn't make the problem
clear. I've never seen merge fields that tell me whether the "Mailing
Address" is Business or Home, and of course many contacts have both. So what
condition(s) would I check for? The absence or presence of the Company Name
does not tell me which is the mailing address.

Not easy to do. This is a Word question, not an Outlook question. Post there
on instructions for how to construct a merge using fields that will be
populated conditionally, suppress blank lines if a field is empty, etc.
--
Russ Valentine
[MVP-Outlook]

The mailing addresses in my contacts are a mix of home and business
addresses. I want to do a mail merge that includes the company name only
when
the business address is the mailing address. Using Outllook 2003 SP2. Is
this
easy and I've just missed it? Doable with coding or 3rd party tool? Thanks
in
advance!

 

[Russ Valentine [MVP-Outlook]]

My suggestion remains unchanged. You are not asking Outlook questions here.
What you specify as the mailing address in Outlook is of no consequence when
it comes to constructing the complex merge you described. The Mailing
Address is a derived field in Outlook. You would not use a derived field for
a merge in Word under the circumstances you require. You would use the
individual address elements which comprise them. And you would need to set
the conditions for which field is used and what to do if that field is not
populated--all Word questions.
--
Russ Valentine
[MVP-Outlook]

I'm sorry, I must be missing something, or perhaps I didn't make the
problem
clear. I've never seen merge fields that tell me whether the "Mailing
Address" is Business or Home, and of course many contacts have both. So
what
condition(s) would I check for? The absence or presence of the Company
Name
does not tell me which is the mailing address.

Not easy to do. This is a Word question, not an Outlook question. Post
there
on instructions for how to construct a merge using fields that will be
populated conditionally, suppress blank lines if a field is empty, etc.
--
Russ Valentine
[MVP-Outlook]

The mailing addresses in my contacts are a mix of home and business
addresses. I want to do a mail merge that includes the company name
only
when
the business address is the mailing address. Using Outllook 2003 SP2.
Is
this
easy and I've just missed it? Doable with coding or 3rd party tool?
Thanks
in
advance!

 

[Guest]

Sorry if I'm persisting too much, but I still think there's an Outlook issue
here: How does Outlook expose the value in the contacts checkbox "This is the
mailing address?" The closest I can find is "Mailng Address Indicator" - but
it always comes up blank. Without the information in that checkbox, no
condition can be tested, and I've simply never seen it in either an export or
a Merge Field list.

Thanks for your patience!

My suggestion remains unchanged. You are not asking Outlook questions here.
What you specify as the mailing address in Outlook is of no consequence when
it comes to constructing the complex merge you described. The Mailing
Address is a derived field in Outlook. You would not use a derived field for
a merge in Word under the circumstances you require. You would use the
individual address elements which comprise them. And you would need to set
the conditions for which field is used and what to do if that field is not
populated--all Word questions.
--
Russ Valentine
[MVP-Outlook]

I'm sorry, I must be missing something, or perhaps I didn't make the
problem
clear. I've never seen merge fields that tell me whether the "Mailing
Address" is Business or Home, and of course many contacts have both. So
what
condition(s) would I check for? The absence or presence of the Company
Name
does not tell me which is the mailing address.

Not easy to do. This is a Word question, not an Outlook question. Post
there
on instructions for how to construct a merge using fields that will be
populated conditionally, suppress blank lines if a field is empty, etc.
--
Russ Valentine
[MVP-Outlook]
The mailing addresses in my contacts are a mix of home and business
addresses. I want to do a mail merge that includes the company name
only
when
the business address is the mailing address. Using Outllook 2003 SP2.
Is
this
easy and I've just missed it? Doable with coding or 3rd party tool?
Thanks
in
advance!

 

[Russ Valentine [MVP-Outlook]]

When you start a merge from Outlook, then Outlook's fields will be available
to you for a simple merge, including its derived fields such as "Mailing
Address."
However, if you described accurately what you wanted to do, that would not
serve your needs. You described a complex merge based on conditions (note
your phrase "only when" in your post). That's a much tougher nut to crack.
You must use Word's "Insert Word Field" function which will permit
conditional merges and construct your merge layout very carefully so you can
suppress blank lines when a field is not populated.
There are not Outlook questions. Read Word's Help pages. Read Word's KB.
Post in a Word group to see if anyone there knows how to do this.
--
Russ Valentine
[MVP-Outlook]

Sorry if I'm persisting too much, but I still think there's an Outlook
issue
here: How does Outlook expose the value in the contacts checkbox "This is
the
mailing address?" The closest I can find is "Mailng Address Indicator" -
but
it always comes up blank. Without the information in that checkbox, no
condition can be tested, and I've simply never seen it in either an export
or
a Merge Field list.

Thanks for your patience!

My suggestion remains unchanged. You are not asking Outlook questions
here.
What you specify as the mailing address in Outlook is of no consequence
when
it comes to constructing the complex merge you described. The Mailing
Address is a derived field in Outlook. You would not use a derived field
for
a merge in Word under the circumstances you require. You would use the
individual address elements which comprise them. And you would need to
set
the conditions for which field is used and what to do if that field is
not
populated--all Word questions.
--
Russ Valentine
[MVP-Outlook]

I'm sorry, I must be missing something, or perhaps I didn't make the
problem
clear. I've never seen merge fields that tell me whether the "Mailing
Address" is Business or Home, and of course many contacts have both. So
what
condition(s) would I check for? The absence or presence of the Company
Name
does not tell me which is the mailing address.

:

Not easy to do. This is a Word question, not an Outlook question. Post
there
on instructions for how to construct a merge using fields that will be
populated conditionally, suppress blank lines if a field is empty,
etc.
--
Russ Valentine
[MVP-Outlook]
The mailing addresses in my contacts are a mix of home and business
addresses. I want to do a mail merge that includes the company name
only
when
the business address is the mailing address. Using Outllook 2003
SP2.
Is
this
easy and I've just missed it? Doable with coding or 3rd party tool?
Thanks
in
advance!