View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Email a text file from within a userform

Hi Tom/Pierre

It might be possible if you want to write code for every possible mail client. (some would just be a kludge using sendkeys).


Not with a attachment I think ?

You can try this for body text
http://www.rondebruin.nl/mail/oebody.htm



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



"Tom Ogilvy" wrote in message ...
It might be possible if you want to write code for every possible mail client. (some would just be a kludge using sendkeys).

It is probably possible to send the email without getting the mail client involved.

http://www.rondebruin.nl/sendmail.htm

--
Regards,
Tom Ogilvy


"Pierre Archambault" wrote in message ...
Hi

I need to be able to send an Email to a defined recipient and include a texte file as attachment.

This has to be done in a UserForm only by clicking a CommandButton.

I need to be able to open the default email client with the recipient's address, the subject and the attached file already there.

The user just have to press the "Send" button.

Is this possible?

Thanks

Pierre