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

Tip: Looking for answers? Try searching our database.

mail merge recipient fields display in selected order

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AuctionJan - 21 Feb 2006 21:11 GMT
The Mail Merge Recipients box displays columns such as Last Name, First
Name, Address, City, State, Zip, and Customer ID #.  How can I rearrange the
columns so that my Customer ID # is the first column I see and not way over
on the right hand side of the screen?
Peter Jamieson - 21 Feb 2006 21:15 GMT
You can drag and drop the column within the recipients box, each time you
open the box, but I do not think anyone knows a way to save the settings so
that the dialog box remembers the seqeunce of columns that you specified.

Peter Jamieson
> The Mail Merge Recipients box displays columns such as Last Name, First
> Name, Address, City, State, Zip, and Customer ID #.  How can I rearrange
> the
> columns so that my Customer ID # is the first column I see and not way
> over
> on the right hand side of the screen?
AuctionJan - 21 Feb 2006 21:26 GMT
I agree.  I know I can drag it over, but we do mail merges MANY times each
day and the best way to assure the correct names are chosen is to use the
unique customer ID.  What's strange is that the Customer ID is a unique
number assigned by our Access database and it is the FIRST data field in the
Access record.  Why it has to be way after all the other data fields during
the mail merge is beyond me.

> You can drag and drop the column within the recipients box, each time you
> open the box, but I do not think anyone knows a way to save the settings so
[quoted text clipped - 7 lines]
> > over
> > on the right hand side of the screen?
Peter Jamieson - 21 Feb 2006 22:00 GMT
I dont work for Microsoft and can only guess what drives their user
interface design.

The only thing I can suggest is that you experiment with naming every column
in your data source in such a way that the columns appear in the sequence
you want. My guess is that Microsoft's software tries to match standard
address column names such as firstname, lastname, street, city, etc, and
will always present recognised names in a certain sequence. Maybe, if it
makes sense to you, you could name your columns 01_something,
02_somethingelse, and so on, and they will appear in that sequence. Awkward
for the users, maybe, but perhaps better than the alternative. Maybe you
could use an Access query to do it.

Peter Jamieson
>I agree.  I know I can drag it over, but we do mail merges MANY times each
> day and the best way to assure the correct names are chosen is to use the
[quoted text clipped - 18 lines]
>> > over
>> > on the right hand side of the screen?
 
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.