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 / July 2006

Tip: Looking for answers? Try searching our database.

Sort Mass mailings by zip code which are in its own field?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
N Locatis - 12 Jul 2006 20:05 GMT
mass mailings and sort by zip codes to eliminate having to do it by hand
after the printing.
Peter Jamieson - 12 Jul 2006 23:05 GMT
You should be able to use the Mail merge recipients dialog box to sort a
particular column by clicking on the column header. With ZIP codes that will
probably depend on all the ZIP codes being numeric and having the same
format (e.g. you would not be able to sort UK postcodes and probably not
Canadian postcodes this way).

However, it is probably better to ensure that the data source is sorted if
possible. If it's Access, create a QUERY that defines a sort sequence (i.e.
uses an ORDER by clause in the SQL). For an Excel file, you could use
Excel's own sorting facilities before opening the data source.

Peter Jamieson
> mass mailings and sort by zip codes to eliminate having to do it by hand
> after the printing.
 
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.