 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / October 2008sending emails from access through outlook
i have 2 problems with sending emails from access through outlook: 1. outlook reports that the email has not been sent even it in sent items folder. 2. how can i format the email (font, color, align)? thanks If it is programmable in Outlook VBA, you can do it from Access by setting a reference (early binding) or by using late binding. Get the code you need from an Outlook newsgroup and post it here. An example of Outlook automation from Access is at: http://www.datastrat.com/Code/OutlookEmail.txt You may also want to look at Outlook Redemption to deal with Outlook security prompts: http://www.dimastr.com/redemption/  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com >i have 2 problems with sending emails from access through outlook: > 1. outlook reports that the email has not been sent even it in sent items > folder. > 2. how can i format the email (font, color, align)? > > thanks I've tried the code: Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem But I get: Compile Error: User-defined type not defined Thanks, J. > If it is programmable in Outlook VBA, you can do it from Access by setting > a reference (early binding) or by using late binding. Get the code you [quoted text clipped - 13 lines] >> >> thanks Did you set references? You can either set a reference to Outlook in any code window, which will run the code slightly faster, or you can change the code from: Dim objOutlook As Outlook.Application to: Dim objOutlook As Object SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > I've tried the code: Dim objOutlook As Outlook.Application > Dim objEmail As Outlook.MailItem [quoted text clipped - 21 lines] >>> >>> thanks I have created the reference under tools for Outlook. > Did you set references? You can either set a reference to Outlook in any > code window, which will run the code slightly faster, or you can change [quoted text clipped - 29 lines] >>>> >>>> thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.