Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
SOJ SOJ is offline
external usenet poster
 
Posts: 1
Default How do I send a xl-sheet as a mail using a VBA-script?

I'm trying to create a macro that sends the active excel-sheet to
mail-recipients.
I use "record a macro" and perform all the steps and even sends the mail.
When I stop recording the script is empty.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default How do I send a xl-sheet as a mail using a VBA-script?

Hi SOJ,

See Ron de Bruin's SendMail page for samole code:

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

---
Regards,
Norman



"SOJ" wrote in message
...
I'm trying to create a macro that sends the active excel-sheet to
mail-recipients.
I use "record a macro" and perform all the steps and even sends the mail.
When I stop recording the script is empty.



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
Bypass: A program is trying to send mail using Item.Send prompt Vick Excel Discussion (Misc queries) 1 June 25th 09 03:31 AM
cannot send excel worksheet (sheet only) to mail recipient Nancy Excel Discussion (Misc queries) 1 November 9th 05 08:54 PM
Send Mail Script Help JBL Excel Programming 5 June 22nd 05 10:06 AM
Script to send jenelle Excel Programming 1 January 7th 05 05:11 PM
Strange request Automaticaly send spread sheet as an e-mail Gill Excel Programming 1 December 19th 04 06:30 AM


All times are GMT +1. The time now is 05:24 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"