Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2007

Tip: Looking for answers? Try searching our database.

Mail Merge/ Outlook 2003 - Zip Codes in Order

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PatrickM - 05 Jun 2007 16:43 GMT
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?
Peter Jamieson - 05 Jun 2007 17:21 GMT
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

>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
[quoted text clipped - 8 lines]
> merge
> the labels are placed in the correct order for printing?
PatrickM - 05 Jun 2007 18:23 GMT
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?
Peter Jamieson - 05 Jun 2007 18:52 GMT
> 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

> When I click on the "Select available fields from" - first of all it
> already
[quoted text clipped - 21 lines]
>
> Suggestions?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.