Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge Field Order
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 |
#2
|
|||
|
|||
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 "KTJ" wrote in message ups.com... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge field different in datasource & insert a field menu | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Switch an image dynamically based on mail merge field - possible? | Mailmerge | |||
Mail Merge Field Stripping | Mailmerge | |||
How do I get a field to self adjust in a mail merge? | Mailmerge |