By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,516 Members | 936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,516 IT Pros & Developers. It's quick & easy.

Prompted Query Fileds and Mail Merge

P: 44
I am creating letters from selected Access records using a Mail Merge document in Word. The mail merge document gets its data from a one-record table that is created from a Make-Table query that gets run when the command button that opens the letter is run. In this query there is a prompted field, i.e. the query asks the user for the value that is to be placed in the field. The query runs fine and the table is created successfully and the prompted value is stored in the table just as expected. However, the mail merge document won't recognize that particular field even though it appears just like any other field in the table. What gives? And what needs to be done to make it work right?

(I also tried using the "Fill-In" function from Word to accomplish this and I can't get the document to actually prompt for a value except at the time when the field is first created - so it does no good.)

I appreciate any insight that anyone can offer. Thanks.
Mar 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,770
I can't offer much help here I'm afraid as I know very little about using Mail-Merge in Office.
What seems obvious though, is that your newly created field is somehow different from the other data that is working. To determine what is different, any member trying to help would need details about what you're storing, where and how. It's hard to know in advance exactly what information is required, but none is certainly not going to help much.
Mar 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.