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 2005

Tip: Looking for answers? Try searching our database.

Mail Merge Field Order

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KTJ - 13 Jun 2005 12:37 GMT
Hi all,

im having problems with mail merge and access DB's.  I want to connect
to an access table to create mailing letters.  It works fine apart from
the fact that in the 'edit recipients' dialogue box, the fields are in
a different order to how they are in the access table.

Now this is a problem that has happened only recently and as far as I
remember it never did this before.

Any ideas how this happened and how to avoid Word deciding on its own
field order?

Cheers

KTJ
Peter Jamieson - 13 Jun 2005 18:09 GMT
I have never found a way to specify the sequence and I am reasonably sure
that Word has always decided the sequence - I could be wrong of course but
wonder if you are remembering some other sequence, e.g. the sequence of
fields in a drop-down, perhaps in an earlier version of Word?

I suspect the only way to impose a sequence is to use field names that Word
fails to recognise (it will probably only try to recognise fields with the
sort of names you would find in an address database) - e.g. if you call your
fields 1name, 2street, 3city etc. you might force a sequence. You could do
that by assigning alias names in an Access query to avoid disturbing the
names in your underlying Access table(s).

Peter Jamieson

> Hi all,
>
[quoted text clipped - 12 lines]
>
> KTJ
 
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.