Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
 
Posts: n/a
Default data source not showing

(Word & Access 2003 in Windows XP)

I was working today with someone who wanted to do a merge in Word,
using a data source from Access. I am very experienced in Access, and
so I helped her develop the right query in Access to create the dataset
she needed for her letters in Word.

When we went to Word and started the merge wizard, at the screen where
you identify your data source, I had no trouble finding the correct
database file, but my query didn't show in the list of tables and
queries. I tried over and over. I tried closing and reopening Word
and also the database, but every time ALL the tables and queries would
show in the list except the one that I'd just made for her.

Eventually, I just created the letter for her in Access with that query
as the data source, and she'll run the letters as reports from there.
I built in enough flexibility in Access for her to be able to use it
for a long time. But I want to help her understand how she can write
her own letters in Word and merge 'em with Access data.

Anyone know why this query would disappear every time I wanted to
identify it in the Word merge process, but it was right there in the
database?

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a read-only mail merge data source? Julie Mailmerge 3 November 16th 05 07:23 PM
Unable to change data source [email protected] Mailmerge 0 October 12th 05 06:02 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Cannot Find Its Data Source Dave Foote Mailmerge 3 December 17th 04 11:27 AM


All times are GMT +1. The time now is 08:54 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"