ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   email as a group - multiple worksheets from one workbook (https://www.excelbanter.com/excel-programming/309697-email-group-multiple-worksheets-one-workbook.html)

Penny

email as a group - multiple worksheets from one workbook
 
I have Excell 2002 - and I need to email more than one worksheet out of a
workbook. I have about 10 worksheets all of which are linked to one another
in some way. At times I want to select a few of this worksheets and email
them as a group. But so farI can only send one worksheet at a time or the
whole workbook.
--
Penny

Gord Dibben

email as a group - multiple worksheets from one workbook
 
Penny

Use code from Ron de Bruin's site or download his FREE SendMail add-in.

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

Gord Dibben Excel MVP

On Sun, 12 Sep 2004 10:03:01 -0700, "Penny"
wrote:

I have Excell 2002 - and I need to email more than one worksheet out of a
workbook. I have about 10 worksheets all of which are linked to one another
in some way. At times I want to select a few of this worksheets and email
them as a group. But so farI can only send one worksheet at a time or the
whole workbook.



Penny

email as a group - multiple worksheets from one workbook
 
I have done everything as per instructions, downloaded into my office/library
and even office/addins but not getting it to work. Have downloaded and used
the user guide, any suggestions?

penny

"Gord Dibben" wrote:

Penny

Use code from Ron de Bruin's site or download his FREE SendMail add-in.

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

Gord Dibben Excel MVP

On Sun, 12 Sep 2004 10:03:01 -0700, "Penny"
wrote:

I have Excell 2002 - and I need to email more than one worksheet out of a
workbook. I have about 10 worksheets all of which are linked to one another
in some way. At times I want to select a few of this worksheets and email
them as a group. But so farI can only send one worksheet at a time or the
whole workbook.




Gord Dibben

email as a group - multiple worksheets from one workbook
 
Penny

What is "not getting it to work"?

Won't appear on the Tools Menu? Have you check-marked it in ToolsAdd-ins?

Won't interface with Outlook? Did you download the 3.22 version?

Please post back with some details.

Gord

On Sun, 12 Sep 2004 16:07:06 -0700, "Penny"
wrote:

I have done everything as per instructions, downloaded into my office/library
and even office/addins but not getting it to work. Have downloaded and used
the user guide, any suggestions?

penny

"Gord Dibben" wrote:

Penny

Use code from Ron de Bruin's site or download his FREE SendMail add-in.

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

Gord Dibben Excel MVP

On Sun, 12 Sep 2004 10:03:01 -0700, "Penny"
wrote:

I have Excell 2002 - and I need to email more than one worksheet out of a
workbook. I have about 10 worksheets all of which are linked to one another
in some way. At times I want to select a few of this worksheets and email
them as a group. But so farI can only send one worksheet at a time or the
whole workbook.





Ron de Bruin

email as a group - multiple worksheets from one workbook
 
Hi

Won't interface with Outlook? Did you download the 3.22 version?

3.22 = Outlook and 2.2 is for Outlook or Outlook Express

Also check out this page
http://www.rondebruin.nl/mail/problems.htm

See Number 2


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


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Penny

What is "not getting it to work"?

Won't appear on the Tools Menu? Have you check-marked it in ToolsAdd-ins?

Won't interface with Outlook? Did you download the 3.22 version?

Please post back with some details.

Gord

On Sun, 12 Sep 2004 16:07:06 -0700, "Penny"
wrote:

I have done everything as per instructions, downloaded into my office/library
and even office/addins but not getting it to work. Have downloaded and used
the user guide, any suggestions?

penny

"Gord Dibben" wrote:

Penny

Use code from Ron de Bruin's site or download his FREE SendMail add-in.

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

Gord Dibben Excel MVP

On Sun, 12 Sep 2004 10:03:01 -0700, "Penny"
wrote:

I have Excell 2002 - and I need to email more than one worksheet out of a
workbook. I have about 10 worksheets all of which are linked to one another
in some way. At times I want to select a few of this worksheets and email
them as a group. But so farI can only send one worksheet at a time or the
whole workbook.






Gord Dibben

email as a group - multiple worksheets from one workbook
 
Penny

The usual folder for Add-ins is the Office\Library folder.

If you place the sendmail.xla in there, Excel will find and list it in the
ToolsAdd-ins dialog.

If you want to store it in a different folder, go to ToolsAdd-ins and
"Browse" to your folder.

Gord

On Mon, 13 Sep 2004 06:49:02 -0700, "Penny"
wrote:

I have downloaded 2.2 version and went in to access from a "new" excel
workbook, and in the "add-in" on the tool menu there is no reference for
this particular add-in to be checked. I will try the 3.22 version- for some
reason I was thinking that was to be used for Outlook/Express only.

Thank you, I will let you know.

Penny

"Gord Dibben" wrote:

Penny

What is "not getting it to work"?

Won't appear on the Tools Menu? Have you check-marked it in ToolsAdd-ins?

Won't interface with Outlook? Did you download the 3.22 version?

Please post back with some details.

Gord

On Sun, 12 Sep 2004 16:07:06 -0700, "Penny"
wrote:

I have done everything as per instructions, downloaded into my office/library
and even office/addins but not getting it to work. Have downloaded and used
the user guide, any suggestions?

penny

"Gord Dibben" wrote:

Penny

Use code from Ron de Bruin's site or download his FREE SendMail add-in.

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

Gord Dibben Excel MVP

On Sun, 12 Sep 2004 10:03:01 -0700, "Penny"
wrote:

I have Excell 2002 - and I need to email more than one worksheet out of a
workbook. I have about 10 worksheets all of which are linked to one another
in some way. At times I want to select a few of this worksheets and email
them as a group. But so farI can only send one worksheet at a time or the
whole workbook.







All times are GMT +1. The time now is 02:05 PM.

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