• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Outlook VBA Code

Hello,
I have an Access database that performs various functions and at the end I want a blank email message to open with only the subject line filled in as well as an attachment added.  I'd like to do this all from VBA but I don't know what code to use.  I know how to send an email using VBA and the MAPI interface but I'd prefer to just have a blank message open with limit fields pre-populated so that the user can fill in the "To" field.  I know there are better ways to process emails from Access that don't require any user interaction but the person I'm coding this for does not want that type of functionality for whatever reason.  Any help would be appreciated.

Thanks.
0
liquid22
Asked:
liquid22
1 Solution
 
jessnjeffCommented:
THere is plenty of code out there.

Try here www.slipstick.com, here is the exact page:  http://www.outlookcode.com/d/database.htm

Also an Access site with connection & email code here:
http://www.helenfeddema.com/CodeSamples.htm , search the page for Outlook, they are down near the bottom.


0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now