LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i email the contents of a userform? Richard[_36_] Excel Programming 4 March 2nd 06 02:33 AM
Email Userform gachett Excel Discussion (Misc queries) 0 December 28th 05 04:53 PM
Email a Userform Stuart[_21_] Excel Programming 3 March 23rd 05 03:57 PM
Userform and Cell Email Hyperlink scain2004[_13_] Excel Programming 0 May 20th 04 03:25 AM
Send a Userform by email Fede Querio Excel Programming 0 July 27th 03 11:06 PM


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"