Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting select group of worksheets within a workbook | Excel Worksheet Functions | |||
can you group multiple worksheets into a sub menu | Excel Worksheet Functions | |||
How do I group and edit multiple worksheets? | Excel Worksheet Functions | |||
Can I email unique worksheets from a workbook to different users? | Excel Discussion (Misc queries) | |||
How do i group worksheets inside a workbook into subgroups? | Excel Worksheet Functions |