Access 2007 - macro automation contiguous emails webserver - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Access 2007 - macro automation contiguous emails webserver

josmojosmo Bellevue, WAPosts: 0Member

webserver email code other than resorting to Inetpub www directory; how to setup an email macro automation and change/replace the file name continuously, (one after the other automation) after sending daily file names...(not sure how to include a macro or VBA or module code); I'm able to send the email through macro but receive prompts and would want to automate sending an .html file and .xls record file and then automate additional re-writes after deleting the table and accepting more records;

currently the macro configuration is; line one "openform - Customers1"; second line "find record = 100"; third line "Open Query - Over 100"; fourth line - "Output to - table-customers"; fifth line "Close"; sixth line "transferspreadsheet - export"; seventh line "Clear macro error"; eighth line "send object - Table-customer"; eighth line "transfer text-export Html"

Sign In or Register to comment.