Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Hi Jeff - you probably didn't see the question I asked in reply to your (?)
previous thread: Can you use /any/ of the queries (or tables) in your database as a data source via DDE? -- Peter Jamieson http://tips.pjmsn.me.uk "Jeff W." Jeff wrote in message ... I am using Office 2003 in Windows XP. I am merging with and Access Database and the query with which I link has a critieria ([Name]). I follow the steps outlined by Microsoft as to how to open a DDE link with Access, and it works great in Windows 2000, but not in XP. These are the steps I follow (from the Microsoft help site): WORKAROUND To work around this problem, confirm that Word uses Dynamic Data Exchange (DDE) when you attach the Access database to the mail merge document. To do this, follow these steps: 1. Open a new blank document. 2. On the Tools menu, click Options, and then click the General tab. 3. Click to select the Confirm conversion at Open check box, and then click OK. 4. On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard. 5. Under Select document type, click the type that you want, and then click Next: Starting document. 6. Under Select starting document, click the document that you want to use, and then click Next: Select recipients. 7. Under Select recipients, click Use an existing list, and then click Browse under Use an existing list. 8. Locate and open the folder that contains the Access database that you want to use as your data source, click the database, and then click Open. 9. In the Confirm Data Source dialog box, click MS Access Databases via DDE (*.mdb, *.mde), and then click OK. 10. In the Microsoft Access dialog box, click the Queries tab, click the query that you want to use, and then click OK. But when I choose the query I want, instead of giving me the criteria dialog box (like it does in 2000) it gives me the "Find Data Source" dialog box again. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox and Access query in Word? | Microsoft Word Help | |||
Access query merging into Word doesn't work | Mailmerge | |||
Word Doc connected to Access Query | Mailmerge | |||
Why do I get an empty table from an access query in Word | Mailmerge | |||
Mail Merge Access to Word using a Query | Mailmerge |