mail sheet as body from userform
 

i got 4 checkboxes linked to cells on sheet1

and a commandbutton1.

when userclick that button i need the print range on sheet on to be mailed
with the defauld mail client to

any sugestions?

mail sheet as body from userform
 

with the defauld mail client

Not possible to send a range in the body with every mail program

See the Outlook example on my site en also the CDO page
http://www.rondebruin.nl/sendmail.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pswanie" wrote in message ...
i got 4 checkboxes linked to cells on sheet1

and a commandbutton1.

when userclick that button i need the print range on sheet on to be mailed
with the defauld mail client to

any sugestions?