By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,312 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,312 IT Pros & Developers. It's quick & easy.

Send email through Outlook from list box

P: n/a
Hi all! I'm trying to set up an email application for my database. I tried
linking to my Outlook address book, but when reading from the table, I
receive an error message saying I need to restart Access. So I set up a
table and a form for users to add email addresses. I have another form
(Email_Report) that allows the user to select multiple addresses from a list
box and has two hidden fields (Subject and Body) that are preset with text.
I want the user to be able to run any report in the database and upon closing
the report, be presented with a message asking whether they would like to
send the report or not. Obviously, saying no will simply return the user to
the main menu. If they click yes, I want to export the report to a preset
location with a preset file name (no matter what report they choose). I then
want the Email_Report form to open. Upon clicking the Send button on the
form, Outlook opens with the correct address(es), Subject, Body, and the
attachment (exported report). I would love for it to automatically send, but
that's not all that important right now. I know I'll need a macro to export
my reports, but so far I haven't gotten anywhere with the email part.
Any help is greatly appreciated. Thanks!

Message posted via

Feb 7 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.