Mail Merge Recipient List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Laumann - 15 Jan 2006 02:55 GMT

I successfully created a mail merge in Word 2003 and the 'EDIT' button in the
MAIL MERGE RECIPIENTS dialog box allowed me to edit and customize the fields.
I then opened the Address List file with the mdb extension in Access 2003.
Now I can no longer use the EDIT button to add recipients.

Thanks in advance for any assistance. Jim

Reply to this Message

Graham Mayor - 15 Jan 2006 06:34 GMT

There does not appear to be anything in the editing of the data file in
Access that would prevent the file from being used with Word's merge tools.
Did you re-attach the data after editing it in Access?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I successfully created a mail merge in Word 2003 and the 'EDIT'
> button in the MAIL MERGE RECIPIENTS dialog box allowed me to edit and
[quoted text clipped - 3 lines]
>
> Thanks in advance for any assistance. Jim

Reply to this Message

Jim Laumann - 15 Jan 2006 12:17 GMT

Graham,

Thank you for the reply. Yes, I did re-attach. After an hour or so of
different solutions, I found that I had changed a field name in Access. Even
though, the corresponding Word field was also corrected, the database
apparently corrupted. I checked the field properties in Access to see if
something else was affected. No luck. Once I recreated the Recipient List
in Word using the "exact" field names (over 40 fields) in the document and
reattached, the problem was solved.

It is important to be able to open the Access File since the client (Law
Firm) will be importing records from a previous merge file that was used with
WordPerfect into the new Access database.

Again, your reply was appreciated.

Jim

> There does not appear to be anything in the editing of the data file in
> Access that would prevent the file from being used with Word's merge tools.
[quoted text clipped - 7 lines]
> >
> > Thanks in advance for any assistance. Jim

Reply to this Message

Peter Jamieson - 15 Jan 2006 14:31 GMT

Word treats Office Address Lists (OALs) differently from other .mdb files,
e.g. in that it lets you edit them from within Word. Word is quite finickity
when it decides whether a .mdb is an OAL or not. There has to be a table
with a specific name, a query with a specific name, and specific fields (I'd
tell you the precise specification if only I knew what it was). For example,
add one or two more tables in the .mdb and Word will not recognise it as an
OAL.

Peter Jamieson

> Graham,
>
[quoted text clipped - 29 lines]
>> >
>> > Thanks in advance for any assistance. Jim

Reply to this Message