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

Rabu, 09 September 2015

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

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