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

Kamis, 10 September 2015

Re: [MS_AccessPros] send email in html format

Kevin-

In AD's code, look in module M_SendReport at the P_ReportInMailBody_DirectHTML function. In that code, he uses the File System Object (FSO) to get the file names rather than Dir. That's probably more efficient.

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:25 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John-

Would please give an example in vba code for using "Dir to final all the page files and process them one at a time."? Thanks a lot.

Kevin

Regards,

Kevin Zhao

From: John Viescas JohnV@msn.com [MS_Access_Professionals]
Date: 2015-09-08 16:45
To: MS_Access_Professionals
Subject: Re: [MS_AccessPros] send email in html format

Giorgio-

You can combine the pages by looking at the HTML as it comes in and eliminating all <A Href></A> pairs as well as the BODY statements for each successive page. Use something like Dir to find all the page files and process them one at a time. Subsequent pages use the original file name with a number appended.

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 8, 2015, at 9:17 AM, giorgio_rovelli <no_reply@yahoogroups.com> wrote:

"Note that this will send only the first page if the report outputs multiple pages."
Hi John, what if the report has multiple pages, do you send each page separately?
Giorgio