Automate - Report to Word then save Word.doc with my filename.

[craigachan]

I looking for help on automating a process, all in Access 2007. I want to export a report to Word 2007 and then automate with a macro if possible to save the word doc with a filename and path location of my choosing. The path and filename could be stored in a [Param] table of some kind.

Anyone have any solutions? Thanks

 

[Premy]

U might want to take a look at this thread
http://www.access-programmers.co.uk/...d.php?t=138021

HTH
Premy

 

[craigachan]

Hi Premy, your link is lost and doesn't come up. Can you let me know what the thread was?

 

[Premy]

Ok sorry, here u go again.

http://www.access-programmers.co.uk/forums/showthread.php?t=138021

If there's a problem again, just copy the link to your browser's address bar and replace the dots by forums/showthrea


Good luck

Premy

 

[craigachan]

Premy,

I examined your code but, being a newbie, I got confused with what applied to me. Basically this is my situation:

I'm using Access 2007 and Word 2007. I'm using an Access table with an attachment field, where I'll store all future word docs for each patient. I want to open a Word template to populate the merge fields and print the letter. Then I want to prompt the user to save the letter, not the template, to the attachment field for later review. When the user is prompted to save the letter, I want to name of the file to be saved as predetermined by my code so that the user won't have to type in any.

Is this possible? Thanks for your help.

 

[craigachan]

I viewed a few more threads and find out it's not a good idea to save in the Access Attachment field. So what I want to do is open a save dialog box that automatically point to a certain directory determined by me. And then save the filename by my code so that all the user has to do is confirm the save.