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

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

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

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

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

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