http://support.microsoft.com/default...b;en-us;816644


Looking at the above webpage I got the information on how to send certain cell's data in an E-mail, but I have a few questions regarding this.

First of all, just wanted to verify with Outlook when you paste cells it pastes the text not a graphic of the cell like other programs such as Lotus Notes, so would this be the same if a macro is sending the e-mail, it would send the text? If not by default is there extra options I need to set in the code.



Secondly, it mentions that it will pop up with an prompt saying that there is an automatic e-mail being sent. Is there an option I can set in the code to pick the option for me? The whole purpose of this is to automate a report that has to be sent via e-mail to cell phone's, so that kind of defeats the whole automation purpose if someone has to select the option.

Hi John

You can find your answers on my site
http://www.rondebruin.nl/sendmail.htm

If you need help post back

--
Regards Ron de Bruin
http://www.rondebruin.nl


"John Tolman" wrote in message ...
http://support.microsoft.com/default...b;en-us;816644


Looking at the above webpage I got the information on how to send certain cell's data in an E-mail, but I have a few questions
regarding this.

First of all, just wanted to verify with Outlook when you paste cells it pastes the text not a graphic of the cell like other
programs such as Lotus Notes, so would this be the same if a macro is sending the e-mail, it would send the text? If not by default
is there extra options I need to set in the code.



Secondly, it mentions that it will pop up with an prompt saying that there is an automatic e-mail being sent. Is there an option I
can set in the code to pick the option for me? The whole purpose of this is to automate a report that has to be sent via e-mail to
cell phone's, so that kind of defeats the whole automation purpose if someone has to select the option.