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 / November 2004

Tip: Looking for answers? Try searching our database.

Repositioning columns of a data source field within the "Edit Recipient List" dialog box within the Mail Merge wizard

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 10 Nov 2004 04:14 GMT
An appeal to a highly-knowledgeable MS Word 2002 guru:

I need to regularly create form letters to send to customers.
My data source for the merge is an Excel 2002 spreadsheet.
Within the data source, there are 51 referenced fields.

Below is a description of the procedure I follow:
1) I start up the mail merge wizard by bringing up a predefinied fax
template.
2) I go to Tools -> Letters and Mailings -> Mail Merge Wizard
3) When prompted, I select *Letters* then *use the current document*
then the *Edit Recipient List* link. The "Mail Merge Recipients"
Dialog box comes up.

Within this dialog, MS Word appears to have "locked" the default order
in which the columns are displayed, starting (from left to right) as
Last Name, First Name, Title, Company Name. These columns *are* able
to be repositioned by method of dragging and dropping, however, their
order is immediately reset the next time this dialog is accessed. The
column that I need moved over to the far left (permanently) is the 8th
column, and a scroll away - it starts to get painful when I need to
reference this column up to 20 times in an hour.

I have tried to change the data source to sort by this column (called
"Ref Number") however, after saving both documents and closing their
applications and reopening them, it doesn't change the order of these
columns (from Last Name, First Name, etc.).

Can anybody please tell me how I can "fix" this order to reflect the
data source (if it can be done)? I've trawled both the Microsoft
online KB and Google groups to no avail.

Many thanks in advance!!

- Dave
Peter Jamieson - 10 Nov 2004 18:19 GMT
Sorry Dave, I am pretty sure you cannot resequence the fields in this dialog
in the way you (and others) wish.

Peter Jamieson

> An appeal to a highly-knowledgeable MS Word 2002 guru:
>
[quoted text clipped - 31 lines]
>
> - Dave
 
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.