ACCESS FEED: Re: [MS_AccessPros] Re: send email in html format

Kamis, 10 September 2015

Re: [MS_AccessPros] Re: send email in html format

John-

Then the code you wrote before sounds more easier, with that I don't need to set reference in outlook, right? I am gonna try your code tonight and let you know how it works. Thank you so much.

Regards,

Kevin

发自我的小米手机

在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年9月10日下午5:13写道：

Kevin-

Did you import AD's objects into your database, or are you just trying to run the code in his sample database? In either case, you need to open the VB Editor (CTRL+G will do it), then choose Compile from the Debug menu. If that gets any errors, you will have to fix them before you proceed. If you imported AD's objects into your database, you have to set references in the VBA project to the Outlook and Word libraries on your machine. Do that from the VB Editor by choosing References from the Tools menu.

Once the code compiles OK, then click the Save button to save the compiled code. Try running again, and if you still get the same error, then go to the VB Editor and choose Options from the Tools menu. On the General tab under Error Trapping, choose "Break on All Errors" and then click OK. Try running the code again - you should see a Debug button on the error dialog, so click that to see the line of code that is failing. Tell us what that is.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Sep 10, 2015, at 1:16 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Bill-,
After click on the "sending this report", it returns " 13 - Type mismatch", what shall I do?
Thanks,
Kevin

Regards,
Kevin Zhao

From: wrmosca@comcast.net [MS_Access_Professionals]
Date: 2015-09-10 04:57
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: send email in html format

Kevin

You might find A.D. Tejpal's sample for sending a report in an email body at http://www.rogersaccesslibrary.com/forum/topic52.html

helpful. The man is a genious when it comes to unusual requests.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@163.com> wrote :

Dear All,
I have learnt how to send html as attachment by the code below.

DoCmd.SendObject acSendReport,"rptReport", acFormatHTML,To:= Email here, Subject:=, Message:=False

My question is, is that possible to send html in email content, instead of as attachment?

Many thanks,
Kevin