how can i select a set number of cells on a worksheet and have tha
information auto duplicated onto an e-mail , I have already a cell fo
e-mails ,once a mail addresss is added and then clicked it aut
launches mail prog all i need is to have the e-mail auto filled (ie
calcs end up as an invoice this invioce now needs to be sent using th
mail address already included in the worksheet this invoice needs t
appear in e-mail ready to send

--
kevat
-----------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...fo&userid=3024
View this thread: http://www.excelforum.com/showthread.php?threadid=50721

You can do anything (almost) but I would suggest formatting a sheet in
the form in which you want your invoice. Then save the sheet as (say)
an HTML file and then use this as an attachment to the email.

This gets around a lot of formatting problems and simplifies the
control.

Hope this helps.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=507210

You may get some help with emailing on Ron de Bruin's pages, though it sounds
like you already have most of it.. http://www.rondebruin.nl/
the macros are in the "Send Mail" link within the Send Mail addins paragraph.-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tony h" wrote in message
...

You can do anything (almost) but I would suggest formatting a sheet in
the form in which you want your invoice. Then save the sheet as (say)
an HTML file and then use this as an attachment to the email.

This gets around a lot of formatting problems and simplifies the
control.

Hope this helps.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=507210