Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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.




  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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.







  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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.





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
Protecting select group of worksheets within a workbook Audrey G. Excel Worksheet Functions 0 July 8th 08 06:16 PM
can you group multiple worksheets into a sub menu ST Jude Excel Worksheet Functions 1 March 29th 07 09:20 PM
How do I group and edit multiple worksheets? LeAnn Excel Worksheet Functions 4 August 1st 06 10:04 PM
Can I email unique worksheets from a workbook to different users? Laura Excel Discussion (Misc queries) 1 November 18th 05 09:52 PM
How do i group worksheets inside a workbook into subgroups? Legatha Excel Worksheet Functions 3 March 19th 05 01:51 AM


All times are GMT +1. The time now is 04:10 AM.

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

About Us

"It's about Microsoft Excel"