Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Outlook VBA Code

Posted on 2004-10-01
1
Medium Priority
?
201 Views
Last Modified: 2010-04-08
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
Comment
Question by:liquid22
1 Comment
 
LVL 8

Accepted Solution

by:
jessnjeff earned 500 total points
ID: 12204495
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

By default Outlook 2016 displays only one time zone in the Calendar. The following article explains how to display two time zones in one calendar view.
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question