Mailing Address Indicator

[Guest]

I am on an Exchange Server using Outlook 2003 with Windows XP. I know that
Outlook has some Contact record fields that are internal use only, one of
which is the Mailing Address Indicator. My problem is that our Mailroom uses
software to certify bulk mailings that does not directly interact with
Outlook, so I need to export any mailing to a database or spreadsheet for
them to use. I want to use the mailing address for my project and I know I
can merge the information to XL or Word or Access, but I can only export the
mailing address as one field. In other words I am not able to separate the
normal address fields of zip code, city, state, and street address. Does
anyone know of a work around? Or, what software should I recommend to our
Mailroom so that they can interface directly with the Outlook database?

I appreciate any help you can provide.

 

[Sue Mosher [MVP-Outlook]]

Sure you can. You can map fields in Outlook's File | IMport and Export
Wizard to generate .csv or .xls files. You can also perform a mail merge to
Word and use the catalog format to generate pretty much any output you want.

 

[Guest]

Thank you for taking time to reply. I know I can map the fields in the home
address, the business address, and the "other" address, but what I want for
my bulk mail project is the address I have identified by the checkbox "This
is the mailing address" in the contact screen (this address can be any one of
the three). I can merge the "mailing address" into the catalog format of
Word, but only with street, city, state and zip as all in one field. I can
do the same thing for XL or even Access.

According to article I finally found on Microsoft's web site (ID
197495-previously Q197495) the Mailing Address and the Mailing Address
Indicator are for Outlook internal use only. This does refer to OL2000. I
could find no reference for newer versions.

The mailing I am doing is to contacts, some of whom I have a home address
only, some have a business address only, some have all three, but I want it
to go to the address I have indicated--using the checkbox-- as the "mailing
address." Because the bulk mail certification software needs that mailing
address parsed into its component parts (ie street address, city, state, zip)
and not all in one field, I am still stuck.

I am sorry to take so much of your time. I am really frustrated at this
point. I was hoping there was some kind of add-in or a bulk mail certifying
software that worked directly with Outlook.

Suzy West

 

[Guest]

Thank you for taking time to reply. I know I can map the fields in the home
address, the business address, and the "other" address, but what I want for
my bulk mail project is the address I have identified by the checkbox "This
is the mailing address" in the contact screen (this address can be any one of
the three). I can merge the "mailing address" into the catalog format of
Word, but only with street, city, state and zip as all in one field. I can
do the same thing for XL or even Access.

According to article I finally found on Microsoft's web site (ID
197495-previously Q197495) the Mailing Address and the Mailing Address
Indicator are for Outlook internal use only. This does refer to OL2000. I
could find no reference for newer versions.

The USPS bulk mailing I am doing is to contacts, some of whom I have a home
address only, some have a business address only, some have all three, but I
want it
to go to the address I have indicated--using the checkbox-- as the "mailing
address." Because the bulk mail certification software needs that mailing
address parsed into its component parts (ie street address, city, state, zip)
and not all in one field, I am still stuck.

I am sorry to take so much of your time. I was hoping there was some kind
of add-in or a bulk mail certifying
software that worked directly with Outlook.