Mail merge requring user input.

[projectmergeleader]

I have created a mail merge that creates letters using information from a
query that needs input from a user. It needs a start and an end date and then
uses that to select from a database. The query works fine if I double click
on it but when I do a mail merge it just starts word and then asks for a
table so I select the temp one and then it complains that it cant find the
field. Access doesn't ask me the questions and then just says command failed
when I close word. I use a where claus in the design view and a criteria
saying Between [start] and [end].

Thanks,

S

 

[Peter Jamieson]

To get Access to ask for the parameters, Word has to connect to the Access
data source using DDE - that's the default in Word 2000 and earlier, but in
Word 2002 and later you need to check WOrd Tools->Options->General->"Confrm
conversions at open@, then go through the process of selecting the data
source agina, and select DDE when offered. In Word 2007, the same option is
in Word Office Button->Word Options->Advanced->General->Confirm file format
conversion on open

 

[projectmergeleader]

I've done that but i have to open the word template and then open the data
source. When I do that I get some unexpected behaviour. Each entry in the
query has a tick box but it always returns -1 instead of true or false,
everything else works fine.

S

To get Access to ask for the parameters, Word has to connect to the Access
data source using DDE - that's the default in Word 2000 and earlier, but in
Word 2002 and later you need to check WOrd Tools->Options->General->"Confrm
conversions at open@, then go through the process of selecting the data
source agina, and select DDE when offered. In Word 2007, the same option is
in Word Office Button->Word Options->Advanced->General->Confirm file format
conversion on open

--
Peter Jamieson
http://tips.pjmsn.me.uk

I have created a mail merge that creates letters using information from a
query that needs input from a user. It needs a start and an end date and
then
uses that to select from a database. The query works fine if I double
click
on it but when I do a mail merge it just starts word and then asks for a
table so I select the temp one and then it complains that it cant find the
field. Access doesn't ask me the questions and then just says command
failed
when I close word. I use a where claus in the design view and a criteria
saying Between [start] and [end].

Thanks,

S

 

[Peter Jamieson]

I've done that but i have to open the word template and then open the data

source.

Yes, unfortunately you have to do this once for each mail merge main
document. But as long as you save the Mail Merge Main document after you
have set up the connection and any sorts/filters you need, you should not
need to do it again.

When I do that I get some unexpected behaviour. Each entry in the
query has a tick box but it always returns -1 instead of true or false,
everything else works fine.

Each connection method (DDE, ODBC, OLEDB) returns the value of an Access
YesNo (bolean) field in a different way. OLE DB returns True and False. DDE
should return -1 and 0, I think. Off the top of my head I can't remember
which way around, but yu can experiment for yourself. If you are using an IF
field with a boolean value from Access, with DDE you have to do something
like

{ IF { MERGEFIELD myvalue } <> 0 "True" "False" }

Alternatively if you want to get the values through to Word as the texts
"True" and "False", you can write an Access query that converts the boolean
value to those values and use that query as the data source for the merge.

--
Peter Jamieson
http://tips.pjmsn.me.uk

I've done that but i have to open the word template and then open the data
source. When I do that I get some unexpected behaviour. Each entry in the
query has a tick box but it always returns -1 instead of true or false,
everything else works fine.

S

To get Access to ask for the parameters, Word has to connect to the
Access
data source using DDE - that's the default in Word 2000 and earlier, but
in
Word 2002 and later you need to check WOrd
Tools->Options->General->"Confrm
conversions at open@, then go through the process of selecting the data
source agina, and select DDE when offered. In Word 2007, the same option
is
in Word Office Button->Word Options->Advanced->General->Confirm file
format
conversion on open

--
Peter Jamieson
http://tips.pjmsn.me.uk

in
message news:[email protected]...

I have created a mail merge that creates letters using information from
a
query that needs input from a user. It needs a start and an end date
and
then
uses that to select from a database. The query works fine if I double
click
on it but when I do a mail merge it just starts word and then asks for
a
table so I select the temp one and then it complains that it cant find
the
field. Access doesn't ask me the questions and then just says command
failed
when I close word. I use a where claus in the design view and a
criteria
saying Between [start] and [end].

Thanks,

S