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