M
Margaret DeCotret
I have a user who is required at different times during the year to provide
certain contact information in a spreadsheet to a particular entity. This
may seem incredibly simple at first glance; however, there are some issues
within the process that really make it a lengthy procedure. My user
maintains very clean and orderly contacts. She properly populates the
correct fields with correct information and utilizes the multiple address
fields together with the mailing address indicator.
When a merge is performed with her contacts, the first issue is the mailing
address itself. Unlike other addresses like Business, Home or Other, there
is no Mailing Address, Mailing Address City, Mailing Address State, etc.,
distinction because it is not a separate set of fields but is only driven by
the mailing address indicator. Once this is in the desired format, whether a
table or a spreadsheet, it must be pulled apart again for the receiving
entity. Along with that is the secondary but equally important issue: My
user would like to provide the Job Title and Company Name where the mailing
address is the business address but exclude such information where the
mailing address is the home address.
Needless to say, parts of these projects end up being treated manually. I
wanted to know if there is a handy solution. I am using Office 2003. Any
wise words would be deeply appreciated. Thanks for reading.
certain contact information in a spreadsheet to a particular entity. This
may seem incredibly simple at first glance; however, there are some issues
within the process that really make it a lengthy procedure. My user
maintains very clean and orderly contacts. She properly populates the
correct fields with correct information and utilizes the multiple address
fields together with the mailing address indicator.
When a merge is performed with her contacts, the first issue is the mailing
address itself. Unlike other addresses like Business, Home or Other, there
is no Mailing Address, Mailing Address City, Mailing Address State, etc.,
distinction because it is not a separate set of fields but is only driven by
the mailing address indicator. Once this is in the desired format, whether a
table or a spreadsheet, it must be pulled apart again for the receiving
entity. Along with that is the secondary but equally important issue: My
user would like to provide the Job Title and Company Name where the mailing
address is the business address but exclude such information where the
mailing address is the home address.
Needless to say, parts of these projects end up being treated manually. I
wanted to know if there is a handy solution. I am using Office 2003. Any
wise words would be deeply appreciated. Thanks for reading.