Mail Merge - Insert Address Block - Insert Country

V

VistaNewbie

I cannot get Outlook to insert the Country on my mailing labels. I have
many labels with addresses in Ireland, Australia, Canada, Spain, etc. I am
using Outlook Contacts as the source for my labels and I have verified that
the address fields in Outlook are correctly populated with the countries
properly selected from the drop menu in the Country/Region Check Address box
in Contacts.

When setting up my labels, I am using the Insert Address Block box. I have
tried the default option for the radio button: Only include the
country/region if different then: United States and the option to Always
include the country/region. Neither produces a label with the country.

What do I need to do to get this option to work?
 
V

VistaNewbie

I changed my labels to use the individual fields, as shown below:

«Courtesy Title» «First Name» «Middle Name» «Last Name»
«Address 1»
«Address 2»
«City», «State» «Postal Code»
«Country or Region»

The country still does not propagate to the label.

Also, the reason I was using the Address Block is that it ignores missing
fields, e.g. in the above layout, the label for "Jane Smith" displays as "
Jane Smith". It has an extra space before the first name (for the missing
Courtesy Title) and an extra space between the first and last name (for the
missing Middle Name).

The extra spaces for every contact with no middle name makes the labels and
form letters look unprofessional.

Diane Poremsky said:
don't use the address block - use the individual fields.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


VistaNewbie said:
I cannot get Outlook to insert the Country on my mailing labels. I have
many labels with addresses in Ireland, Australia, Canada, Spain, etc. I
am using Outlook Contacts as the source for my labels and I have verified
that the address fields in Outlook are correctly populated with the
countries properly selected from the drop menu in the Country/Region
Check Address box in Contacts.

When setting up my labels, I am using the Insert Address Block box. I
have tried the default option for the radio button: Only include the
country/region if different then: United States and the option to Always
include the country/region. Neither produces a label with the country.

What do I need to do to get this option to work?
 
D

Diane Poremsky [MVP]

You can use If statements to get rid of the spaces - but the country should
populate if it exists in the contact.

Are you starting the merge from outlook or word?

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


VistaNewbie said:
I changed my labels to use the individual fields, as shown below:

«Courtesy Title» «First Name» «Middle Name» «Last Name»
«Address 1»
«Address 2»
«City», «State» «Postal Code»
«Country or Region»

The country still does not propagate to the label.

Also, the reason I was using the Address Block is that it ignores missing
fields, e.g. in the above layout, the label for "Jane Smith" displays as "
Jane Smith". It has an extra space before the first name (for the
missing Courtesy Title) and an extra space between the first and last name
(for the missing Middle Name).

The extra spaces for every contact with no middle name makes the labels
and form letters look unprofessional.

Diane Poremsky said:
don't use the address block - use the individual fields.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


VistaNewbie said:
I cannot get Outlook to insert the Country on my mailing labels. I have
many labels with addresses in Ireland, Australia, Canada, Spain, etc. I
am using Outlook Contacts as the source for my labels and I have
verified that the address fields in Outlook are correctly populated with
the countries properly selected from the drop menu in the Country/Region
Check Address box in Contacts.

When setting up my labels, I am using the Insert Address Block box. I
have tried the default option for the radio button: Only include the
country/region if different then: United States and the option to Always
include the country/region. Neither produces a label with the country.

What do I need to do to get this option to work?
 
V

VistaNewbie

I will look into the use of the IF statements.

As I mentioned in my original post, every Contacts record in Outlook has the
country in it. The US contacts default to United States of America. The
others have specific country names, e.g. Ireland, France, etc.

Yes, I start the Mail Merge from Outlook.

After changing the layout to use the individual fields, as indicated in my
reply to your post, I expected to see the country for all the contacts,
including the US addresses but none display.

Diane Poremsky said:
You can use If statements to get rid of the spaces - but the country
should populate if it exists in the contact.

Are you starting the merge from outlook or word?
VistaNewbie said:
I changed my labels to use the individual fields, as shown below:

«Courtesy Title» «First Name» «Middle Name» «Last Name»
«Address 1»
«Address 2»
«City», «State» «Postal Code»
«Country or Region»

The country still does not propagate to the label.

Also, the reason I was using the Address Block is that it ignores missing
fields, e.g. in the above layout, the label for "Jane Smith" displays as
" Jane Smith". It has an extra space before the first name (for the
missing Courtesy Title) and an extra space between the first and last
name (for the missing Middle Name).

The extra spaces for every contact with no middle name makes the labels
and form letters look unprofessional.

Diane Poremsky said:
don't use the address block - use the individual fields.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


I cannot get Outlook to insert the Country on my mailing labels. I
have many labels with addresses in Ireland, Australia, Canada, Spain,
etc. I am using Outlook Contacts as the source for my labels and I
have verified that the address fields in Outlook are correctly
populated with the countries properly selected from the drop menu in
the Country/Region Check Address box in Contacts.

When setting up my labels, I am using the Insert Address Block box. I
have tried the default option for the radio button: Only include the
country/region if different then: United States and the option to
Always include the country/region. Neither produces a label with the
country.

What do I need to do to get this option to work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top