ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using a Macro in Excel to send an embedded sheet via Outlook (https://www.excelbanter.com/excel-discussion-misc-queries/195941-using-macro-excel-send-embedded-sheet-via-outlook.html)

Bill Leffler

Using a Macro in Excel to send an embedded sheet via Outlook
 
Would like to distribute a worksheet to several recipients using Outlook.
Would like to use a macro to load/send the messages. We all have Excel 2003
and Outlook 2003.

The macro "recorder" seems to turn off when I "Send to" a mail recipient.

Is there VB code I can use? Am I missing something?

Thank you....

Ron de Bruin

Using a Macro in Excel to send an embedded sheet via Outlook
 
See this page Bill
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bill Leffler" wrote in message ...
Would like to distribute a worksheet to several recipients using Outlook.
Would like to use a macro to load/send the messages. We all have Excel 2003
and Outlook 2003.

The macro "recorder" seems to turn off when I "Send to" a mail recipient.

Is there VB code I can use? Am I missing something?

Thank you....


Bill Leffler

Using a Macro in Excel to send an embedded sheet via Outlook
 

Ron!

....can't tell you how helpful you have been.

Thank you so much.

...bill....

"Ron de Bruin" wrote:

See this page Bill
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bill Leffler" wrote in message ...
Would like to distribute a worksheet to several recipients using Outlook.
Would like to use a macro to load/send the messages. We all have Excel 2003
and Outlook 2003.

The macro "recorder" seems to turn off when I "Send to" a mail recipient.

Is there VB code I can use? Am I missing something?

Thank you....



Ron de Bruin

Using a Macro in Excel to send an embedded sheet via Outlook
 
You are welcome

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bill Leffler" wrote in message ...

Ron!

...can't tell you how helpful you have been.

Thank you so much.

..bill....

"Ron de Bruin" wrote:

See this page Bill
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bill Leffler" wrote in message
...
Would like to distribute a worksheet to several recipients using Outlook.
Would like to use a macro to load/send the messages. We all have Excel 2003
and Outlook 2003.

The macro "recorder" seems to turn off when I "Send to" a mail recipient.

Is there VB code I can use? Am I missing something?

Thank you....





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com