Send Email using VBA

[dustweb]

Send Email using VBA Version: 2002 (10.0) XP

Posted on 04/28/05 02:00 PM
Posted by dustweb - Utter Access Member
Posts: 13 -

Forum: Access Modules • Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Email Post
• Top of page
Hello,

I have a macro set up to send an email but what I want to do is use code so I can have the TO field read from a form.

Below is the macro and in the TO field is the text field that I want to pull...

Any help is much appricated.

Thank you
Dustweb

OpenReport
SendObject
Object Type = Report
Object Name = rpt_case_transfer_notify
Output Format = Snapshot Format
To = [Current Product]
CC =
Bcc =
Subject = Case Transfer
Message Text = This is to notify you that you have been assigned the Attached Customer for Product(ID Card). If you have any questions please contact me. Thank you
Edit Message = No
Template File =

 

[stevey03]

I don't know how you would do this as such, but there is a web link that may help:

http://www.microsoft-accesssolutions.co.uk/send_email.htm

hope this helps, Steve

 

[dustweb]

Thank you I'll try that.

Dustweb