Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Mail Merge/ Outlook 2003 - Zip Codes in Order

Geek News

Mail Merge/ Outlook 2003 - Zip Codes in Order
PatrickM 6/5/2007 3:43:01 PM
I am having a problem that in Outlook - I cannot get the contacts to sort
according to zip code. I have tried several times - to use the
View
Arrange By
Current View
Customize Current View
Sort : Mailing Addresses

But this still places several labels in the incorrect places according to
zip code. Is there any way to correct this so that when I use the mail merge
the labels are placed in the correct order for printing?
Re: Mail Merge/ Outlook 2003 - Zip Codes in Order
"Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/5/2007 4:21:30 PM
I'm not sure this will work as I have very few addresses with US Zip codes
in my Outlook contacts, but when you get to the "Sort" dialog box", try
changing the "Select avaialble fields from" option to "Address fields", then
select /one/ of the fields that contains "Postal Code" - perhaps
"ZIP/Postal Code".

Peter Jamieson

"PatrickM" <PatrickM[ at ]discussions.microsoft.com> wrote in message
news:56130471-888C-4FE5-A5C0-A269794CFFE7[ at ]microsoft.com...
[Quoted Text]
>I am having a problem that in Outlook - I cannot get the contacts to sort
> according to zip code. I have tried several times - to use the
> View
> Arrange By
> Current View
> Customize Current View
> Sort : Mailing Addresses
>
> But this still places several labels in the incorrect places according to
> zip code. Is there any way to correct this so that when I use the mail
> merge
> the labels are placed in the correct order for printing?

Re: Mail Merge/ Outlook 2003 - Zip Codes in Order
PatrickM 6/5/2007 5:23:01 PM
When I click on the "Select available fields from" - first of all it already
has the "Frequently used fields" notification there - and then it does not
offer the option of Postal Code or Zip/Postal Code or anything even remotely
like it.

I have tried several different options from that list to sort from - but
every time I add a new label and then ask it to "Sort" them again - it
invariably places that label right at the end - no matter how many different
arrangements I put the list in and then try to sort by mailing address again
- it still places any new labels I add on the end.

It's more than a little frustrating that it will sort the entire rest of the
list correctly - but simply places any new ones on the end. I have even
checked similar labels - and made sure all the same "fields" are filled out
correctly/ exactly the same as the fields in the new contact - but it doesn't
seem to matter - it still places them at the end.

Suggestions?
Re: Mail Merge/ Outlook 2003 - Zip Codes in Order
"Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/5/2007 5:52:28 PM
[Quoted Text]
> When I click on the "Select available fields from" - first of all it
> already
> has the "Frequently used fields" notification there

The "Frequently used fields" option is one of several options available
within that dropdown. Click the down-arrow to the right of the box to see
the others.

(/You/ may use the ZIP code freqeuntly, but Outlook evidently has a
different view of what is "Frequently used" :-) (in fact, AFAIK its
descriptions are predefined and unrelated to anything /you/ do)

Peter Jamieson

"PatrickM" <PatrickM[ at ]discussions.microsoft.com> wrote in message
news:B32DFC27-066C-4706-A2D4-750CF61F64E4[ at ]microsoft.com...
> When I click on the "Select available fields from" - first of all it
> already
> has the "Frequently used fields" notification there - and then it does not
> offer the option of Postal Code or Zip/Postal Code or anything even
> remotely
> like it.
>
> I have tried several different options from that list to sort from - but
> every time I add a new label and then ask it to "Sort" them again - it
> invariably places that label right at the end - no matter how many
> different
> arrangements I put the list in and then try to sort by mailing address
> again
> - it still places any new labels I add on the end.
>
> It's more than a little frustrating that it will sort the entire rest of
> the
> list correctly - but simply places any new ones on the end. I have even
> checked similar labels - and made sure all the same "fields" are filled
> out
> correctly/ exactly the same as the fields in the new contact - but it
> doesn't
> seem to matter - it still places them at the end.
>
> Suggestions?

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net