var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is there any way to send e-mails directly from my form in Access and then keeping a record of it for referring to that e-mail in the future.
SEND AN E-MAIL MESSAGE FROM ACCESS
You need an e-mail program that uses MAPI, like Outlook Express:
The above example will put an e-mail message to "ToJohn@doe.com" into your outbox. To have the e-mail send window pop up, change the last parameter to "True". To send to more addresses, separate the addresses with a semicolon. Here's another example that shows where to put CC and Bcc addresses:
DoCmd.SendObject , , , "ToJohn@doe.com;ToBill@doe.com","CcMary@doe.co m" ,"BccSue@doe.com" , "Subject", "Message", False
E-MAIL THE OUTPUT OF A REPORT FROM ACCESS
Here's an example of how to send the output of a report named "Sales By Order" via e-mail. If your report prompts you for parameters, you will be prompted for them when you run this command:
DoCmd.SendObject acSendReport, "Sales By Order", acFormatRTF, "ToJohn@doe.com", , , "Subject", "Message", False
The "acFormatRTF" parameter will send the report output in a format that can be read by MS Word. You can also use:
"acFormatHTML" - Your sent report output will be opened with a web browser.
"acFormatTXT" - Your sent report output will be opened with notepad, or wordpad.
E-MAIL AN ATTACHMENT
To include an attachment with your e-mail, you need to use automation because SendObject won't do this. Here's how to use automation to send an e-mail attachment:
To keep a record of your e-mail correspondence, you could write the subject, message body, and to/from information to a table after sending.
Hope this helps,