What I'm looking to do really doesn't seem that hard but I am really struggling. I have a MSACCESS 2007 form where a user enters data onto the form. I'd like for them to be able to click a button to run a code which will take some of the fields on the current form and open an outlook template and insert the fields in various places in the body, subject and to,cc, etc.
I've tried mailmerge modules and my information is really not a "mass" email it's just one simple email using the data the user just entered and inserting it into a template. I have an outlook template that I'd like to insert the field values into but it never works. I'm using MS ACCESS 2007 and Outlook 2007. I have a code to open a blank email and I can insert the field property into the CC field, which is great, but I can't figure out how to sucessfully integrate with a template.
HELP Please!
I've tried mailmerge modules and my information is really not a "mass" email it's just one simple email using the data the user just entered and inserting it into a template. I have an outlook template that I'd like to insert the field values into but it never works. I'm using MS ACCESS 2007 and Outlook 2007. I have a code to open a blank email and I can insert the field property into the CC field, which is great, but I can't figure out how to sucessfully integrate with a template.
HELP Please!