Word Doc Merge

[ajolson1964]

I am having fits with merging a table with a document using access 2010.
My issues is when I reopen the document it displays {MERGEFIELD "Client_First"} {MERGEFIELD "Client_Last"} in the fields where I would expect to see the first and last name of the client. Also when I click on the mailings button I have to create a new connection to the data source to get it to pick up the record I want.
I am using vba code so that when the user selects the letter they want in Access the file opens.

What seem to be happinging is when the form is opend via VBA the form in not updateing with the new information, nor displaying correctly.

Odd thing is that if I just navigate to the word doucment ( not using the cmd button in access) in explore and open it it asks if I want to reconnect to the data.

What I want is that the user clicks the cmd button in access and the letter oppens and all they view is the results of the merge. Not {MERGEFIELD "Client_First"} {MERGEFIELD "Client_Last"}
Any advice?



thanks

[ajetrumpet]

first of all, "AtestAATest" means absolutely nothing to someone reading this. I'm sure you know that?

Have you tried using the built-in MAIL MERGE action that 2010 offers in the macro builder?

[ajolson1964]

When I reviewed the post I notices that it did not come through as expected here is the correction to the post.
No have not tried the macro. Where do I look for that. Not familar with that.



I am having fits with merging a table with a document using access 2010.
My issues is when I reopen the document it displays {MERGEFIELD "Client_First"} {MERGEFIELD "Client_Last"} in the fields where I would expect to see the first and last name of the client. Also when I click on the mailings button I have to create a new connection to the data source to get it to pick up the record I want.
I am using vba code so that when the user selects the letter they want in Access the file opens.

What seem to be happinging is when the form is opend via VBA the form in not updateing with the new information, nor displaying correctly.

Odd thing is that if I just navigate to the word doucment ( not using the cmd button in access) in explore and open it it asks if I want to reconnect to the data.

What I want is that the user clicks the cmd button in access and the letter oppens and all they view is the results of the merge. Not {MERGEFIELD "Client_First"} {MERGEFIELD "Client_Last"}
Any advice?

thanks

[ajetrumpet]

you find the action in the macro list, sir. if it's not there, click SHOW ALL ACTIONS on the ribbon tab when you're in macro design view.

[ajolson1964]

When I click on the macro Button there are no macros and there is no SHOW ALL ACTIONS . And if I create a new macro on there is no SHOW ALL ACTIONS.

[ajetrumpet]

http://msdn.microsoft.com/en-us/libr..._MacroDesigner