Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default VBA for sending workbook via Outlook

I can select FileSend ToMail Recipient and it will allow me to send a
worksheet as if it were the body of the message. How do I do that with
VBA from within the workbook?

tod

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default VBA for sending workbook via Outlook

See Ron de Bruin's site for sample code:

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

--
Regards,
Tom Ogilvy


"Tod" wrote in message
oups.com...
I can select FileSend ToMail Recipient and it will allow me to send a
worksheet as if it were the body of the message. How do I do that with
VBA from within the workbook?

tod



Reply
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
Sending Excel through Outlook MsNat Excel Discussion (Misc queries) 1 October 21st 09 10:11 PM
Auto sending workbook or sheet as an attachment using Outlook Wyveryn Excel Discussion (Misc queries) 1 October 4th 06 03:52 AM
Workbook minimizes when sending as attachment using Outlook Expres pipepilot Excel Discussion (Misc queries) 0 June 9th 05 03:10 AM
Sending Appointments via Outlook Paul Thompson Excel Programming 3 April 14th 04 12:47 AM
sending outlook mail bilal Excel Programming 1 July 25th 03 01:16 PM


All times are GMT +1. The time now is 07:52 PM.

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"