Merged data from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

markw - 30 Oct 2006 22:30 GMT

I have upgraded from Office 2000 to 2003 and now when I open my word template
to merge data from an access database my records are out of sync i.e. record
no 1 in the database is record No 8 in the merge, also my access database
used to open when I opened the template and now it doesn't. I think its a
data sort problem but can't work out why the database won't open when I open
the merge document.
I don't have a clue about this so can anyone help?????

Reply to this Message

Doug Robbins - Word MVP - 31 Oct 2006 05:35 GMT

I am not sure about the records being out of synch issue, but from the Tools
menu in Word, select Options and then go to the General tab and check the
box against the "Confirm conversions at open" item. Then when you attach
the data source to the mail merge main document, select the DDE option and
your database should then open like it used to.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have upgraded from Office 2000 to 2003 and now when I open my word
>template
[quoted text clipped - 6 lines]
> the merge document.
> I don't have a clue about this so can anyone help?????

Reply to this Message