Mail Merge 'Enter Parameter Value' mystery

[easygoingdave]

I am trying to mail merge from word 2013 to a query in access 2013. I initially had problems displaying the query until I came across a solution regarding connecting via DDE. I can now link to the query but it then asks me to 'enter parameter values' from the query. I have already run these values into the query via a form which ends up in a report. (incidentally I have left the report open). If I manually enter these parameters it works fine. I know I am missing something quite simple, but am still scratching my head, any advice would be very much appreciated.

 

[JHB]

Mostly it is because of a misspelling - fieldname or parameter.
Look what the "enter parameter values" is asking for, at check up. If it is a field name, then check if it really exist in the table.
Else show by printscreen the "enter parameter values" box and the querystring.

 

[easygoingdave]

JHB
Many thanks for responding, but I not sure I fully understand the mail merge process. I had intended to run the query from Access via a form, inputting parameter values which instead of producing a report it would output a mail merge word document to my design (produce an invoice). I thought by linking a word doc to the query, when I ran the query it would auto populate the Word doc. Before continuing,I think I need to get my head round the processes. Thanks again for the advice. Regards Dave

 

[JHB]

You're welcome and luck with your project.

I can't understand why people are using Words for printing documents/invoices where data are stored in MS-Access, when MS-Access reports tools can do it as good as Word! But it is only my opinion.

 

[easygoingdave]

That's exactly what my colleague said, I have now re-designed my report to resemble an invoice. However, I am struggling to get the client's address to compact and fit into a txt box. The main reason I was using Word is the finished product requires emailing to client's, so I will convert the report to a pdf file, unless there is a better way?

 

[JHB]

Try to look at the DoCmd sendobject, maybe it is exactly what you are looking after. From the VBA code window click the Help-file, then you can see all the options for the SendObject.
What is the problem with the address, can't you get it to fit in by setting the control's property "Can Grow" to yes?

DoCmd.SendObject Method

​

The SendObject method carries out the SendObject action in Visual Basic. Syntax
expression.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile)

 

[Pat Hartman]

Word can't "see" the Access form and when Word runs your query, it has only what is in the BE to work with and that means also that it can't use VBA. So the query engine assumes that the Forms!yourform!yourfield is a parameter and prompts for it.

One way to stop this would be to create a table to store the parameter values. So the form would need to be bound to the "criteria" table and save the selection options before starting the mail merge. Then your query would join to that table and no prompting would happen.