asked on

Sending Emails In Access 2002

I have a report with Customers information. Is there anyway to email this via outlook express but have the components of the report (EI - Name, Address, Phone) listed in the body of the email rather than sent as an attachment???? I do not need the email automatically sent, I just need outlook express to open with the report in the main body of the email and an appropriate subject line. Any help would be greatly appreciated!

Thanks,

Tim

ASKER CERTIFIED SOLUTION

rockiroads

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rockiroads

an alternative way is this (note I have not tried this so I do not know how successful it will be, but the last code I posted I know works because I use it in my app and works a treat!)

http://www.vb-helper.com/howto_send_outlook_express_attachment.html

omron60

jjafferr,

I have been able to make everything work except placing the report in the message body. Within your code is .Body = [MessageText] How do I get the report here.

rockiroads,

I don't know how to call the module. I named the module EmailBody

Thank you both for your help.

omron60

Rob4077

Hi rockiroads, if you are still linked to this question can you tell me what references I need to select to get your accepted code to work with Outlook Express. When I run it I get an error at the line that says : Dim objOutlook As Outlook.Application and the error is: Compile error: User-defined type not defined.