View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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?