Outllook address problem

  • Thread starter Thread starter kez
  • Start date Start date
K

kez

As anyone noticed that when you click "New Contact" in a Contacts folder
then click "Address" a window opens up to allow you to enter the first 2 or
3 lines of the address, when these are exported as a mail merge to say excel
or word they do not export as separate fields example "22 MortimerStOldham"
should read be 2 seperate lines not joined togeteher?
This make for much work when you have a big database? is this a problem in
Outlook or can it be fixed? Thanks Keith
 
Addresses in Outlook are composed of a sum of its parts (i.e. street, state,
country etc) and when exported are exported as a single field with line
breaks in the address field (which is valid when using an address for a mail
merge but may not be valid for other uses). Outlook does not export the
individual fields.
How are you parsing the address elements when you create the merge?
 
I just leave it to Outllook?
Russ Valentine said:
Addresses in Outlook are composed of a sum of its parts (i.e. street,
state, country etc) and when exported are exported as a single field with
line breaks in the address field (which is valid when using an address for
a mail merge but may not be valid for other uses). Outlook does not export
the individual fields.
How are you parsing the address elements when you create the merge?
--
Russ Valentine
[MVP-Outlook]
kez said:
As anyone noticed that when you click "New Contact" in a Contacts folder
then click "Address" a window opens up to allow you to enter the first 2
or 3 lines of the address, when these are exported as a mail merge to say
excel or word they do not export as separate fields example "22
MortimerStOldham" should read be 2 seperate lines not joined togeteher?
This make for much work when you have a big database? is this a problem
in Outlook or can it be fixed? Thanks Keith
 
Not possible. You have to construct your merge. Outlook will not do that for
you. Neither will Word.
--
Russ Valentine
[MVP-Outlook]
kez said:
I just leave it to Outllook?
Russ Valentine said:
Addresses in Outlook are composed of a sum of its parts (i.e. street,
state, country etc) and when exported are exported as a single field with
line breaks in the address field (which is valid when using an address
for a mail merge but may not be valid for other uses). Outlook does not
export the individual fields.
How are you parsing the address elements when you create the merge?
--
Russ Valentine
[MVP-Outlook]
kez said:
As anyone noticed that when you click "New Contact" in a Contacts folder
then click "Address" a window opens up to allow you to enter the first 2
or 3 lines of the address, when these are exported as a mail merge to
say excel or word they do not export as separate fields example "22
MortimerStOldham" should read be 2 seperate lines not joined togeteher?
This make for much work when you have a big database? is this a problem
in Outlook or can it be fixed? Thanks Keith
 

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

Back
Top