| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To send a e-mail via Outlook which triggered by excel
I want to automatic the process that when I finish my daily routing of excel
VBA and it can be auto-triggerd the Outlook to send an email with this excel file as an attachment -- Johnosn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To send a e-mail via Outlook which triggered by excel
Hi Johnson
See http://www.rondebruin.nl/sendmail.htm You can use a event to run the macro See this page http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Johnson" wrote in message ... I want to automatic the process that when I finish my daily routing of excel VBA and it can be auto-triggerd the Outlook to send an email with this excel file as an attachment -- Johnosn |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To send a e-mail via Outlook which triggered by excel
First of all, Thanks for your instructions, that I can send an e-mail
triggered from excel macro, but, when the macro is being exectued at the VBA code as shown as below, With olmail .... .send ' when conducting to here, a dialoque box popped up. end with there's a dialoque box popped up and told ma that the sending task is being conducted by a program on behalf of me, and waiting for me till the choice of Yes/No was select. My problem is how can I disable the dialoque box and then sending the mail directly, I would like this task was done with 100% automation. Please help me. Thanks! Johnson Ron de Bruin" wrote: Hi Johnson See http://www.rondebruin.nl/sendmail.htm You can use a event to run the macro See this page http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Johnson" wrote in message ... I want to automatic the process that when I finish my daily routing of excel VBA and it can be auto-triggerd the Outlook to send an email with this excel file as an attachment -- Johnosn |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To send a e-mail via Outlook which triggered by excel
See this page
http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Johnson" wrote in message ... First of all, Thanks for your instructions, that I can send an e-mail triggered from excel macro, but, when the macro is being exectued at the VBA code as shown as below, With olmail .... .send ' when conducting to here, a dialoque box popped up. end with there's a dialoque box popped up and told ma that the sending task is being conducted by a program on behalf of me, and waiting for me till the choice of Yes/No was select. My problem is how can I disable the dialoque box and then sending the mail directly, I would like this task was done with 100% automation. Please help me. Thanks! Johnson Ron de Bruin" wrote: Hi Johnson See http://www.rondebruin.nl/sendmail.htm You can use a event to run the macro See this page http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Johnson" wrote in message ... I want to automatic the process that when I finish my daily routing of excel VBA and it can be auto-triggerd the Outlook to send an email with this excel file as an attachment -- Johnosn |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To send a e-mail via Outlook which triggered by excel
Ron - I am using your site listed below to automatically send an email when a
cell reaches a certain number. I have tested the "cell is a formula" code in a blank workbook by simply summing a column of 1's. It works great right up until I make the manually typed 1's become a formula themselves - like an if statement to say 1 or 0 depending on something in another column. After doing this, the macro to call the email macro will not run. I do not know VBA code that well, but I've gotten by with things like you offer (the cut and paste it method) and things have worked out pretty well. Is the macro not working when the formula cell itself is summing other cells that are also formulas? JenP "Ron de Bruin" wrote: Hi Johnson See http://www.rondebruin.nl/sendmail.htm You can use a event to run the macro See this page http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Johnson" wrote in message ... I want to automatic the process that when I finish my daily routing of excel VBA and it can be auto-triggerd the Outlook to send an email with this excel file as an attachment -- Johnosn |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To send a e-mail via Outlook which triggered by excel
Ron - I apologize - I need to add on my last email that my 1's are
calculating from data from an MS QUERY....it seems like when the query is in the spreadsheet this VBA code does not want to work? Any help would be greatly appreciated. JenP "Ron de Bruin" wrote: Hi Johnson See http://www.rondebruin.nl/sendmail.htm You can use a event to run the macro See this page http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Johnson" wrote in message ... I want to automatic the process that when I finish my daily routing of excel VBA and it can be auto-triggerd the Outlook to send an email with this excel file as an attachment -- Johnosn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| send mail from excel 2000 and Outlook Express | Excel Programming | |||
| Need to send Outlook E-mail from Excel VBA without warnings. | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| Help for Send Mail via Outlook | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Hybrid Mode
