Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Merge won't show data in Access Query?
Hi All,
Not sure what I'm doing wrong. When I create a email merge form letter linked to a Access 2003 query, none of the data shows. Everything is blank. Yet, when I look at the query in Access, there's plenty of data. Any suggestions? pk |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Merge won't show data in Access Query?
I should mention that when I export the query to an Excell file, everything
works fine. "Philip" wrote: Hi All, Not sure what I'm doing wrong. When I create a email merge form letter linked to a Access 2003 query, none of the data shows. Everything is blank. Yet, when I look at the query in Access, there's plenty of data. Any suggestions? pk |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Merge won't show data in Access Query?
If your query uses wildcards (*,%,_ or ?) then there can be a mismatch
between Word/Jet/Access. In that case the quickest fix is probably to check Word Tools|Options|General|Confirm conversions at open, go through the connection process agai, and try the DDE option when offered. it will cause Access to open, which can be a pain if you are setting this up for others to use, but is usually not too problematic if you're just doing the merge yourself. Peter Jamieson "Philip" wrote in message ... Hi All, Not sure what I'm doing wrong. When I create a email merge form letter linked to a Access 2003 query, none of the data shows. Everything is blank. Yet, when I look at the query in Access, there's plenty of data. Any suggestions? pk |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
WP merge file to Word | Tables | |||
How do I consolidate multiple mail merge data files into one file | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
multiple docs, one data source | Mailmerge |