469,638 Members | 1,567 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,638 developers. It's quick & easy.

Prompted Query Fileds and Mail Merge

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
1 1379
32,203 Expert Mod 16PB
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.

Similar topics

reply views Thread by Phil C. | last post: by
2 posts views Thread by zazu | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.