Okay, this is what worked for me in case anyone finds it helpful :
(1)Created the word document
(2) Merged the fields in Access
(3) Created a macro in Word that merges, saves and then e-mails the document
(4) Saved the Macro as AutoOpen
(5)Created a shortcut of the word document, and changed the properties to
open the specific document (Properties > Target)
(6)Created a Macro - RunApp and copied and placed the target line from the
shortcut of the document file.
(7)Created a button that opens the Access Macro, which does all that I need,
package the file, save it and email the document.
I now need to create a code that will pre-fill whom the email is being sent
Any ideas anyone?