| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing selective sheets within a workbook.
http://www.rondebruin.nl/mail/folder2/files.htm
I like the Mail a different file or many files... I tried to use this to selectively send sheets within a workbook. No luck! What would need to be changed? TIA. As a background I have a spreadsheet with 57 sheets with names of town and I'd like to be able to select using this. Nothing like asking for the moon eh! <VBG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing selective sheets within a workbook.
Hi Gary
Install my Add-in http://www.rondebruin.nl/mail/add-in.htm You can select the sheets you want then Or use a template http://www.rondebruin.nl/mail/templates.htm Or use code http://www.rondebruin.nl/mail/folder1/mail3.htm Or http://www.rondebruin.nl/mail/folder2/mail3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... http://www.rondebruin.nl/mail/folder2/files.htm I like the Mail a different file or many files... I tried to use this to selectively send sheets within a workbook. No luck! What would need to be changed? TIA. As a background I have a spreadsheet with 57 sheets with names of town and I'd like to be able to select using this. Nothing like asking for the moon eh! <VBG |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing selective sheets within a workbook.
Cool! I should have asked sooner. I could have saved myself a whack of
thime. <VBG "Ron de Bruin" wrote in message ... Hi Gary Install my Add-in http://www.rondebruin.nl/mail/add-in.htm You can select the sheets you want then Or use a template http://www.rondebruin.nl/mail/templates.htm Or use code http://www.rondebruin.nl/mail/folder1/mail3.htm Or http://www.rondebruin.nl/mail/folder2/mail3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... http://www.rondebruin.nl/mail/folder2/files.htm I like the Mail a different file or many files... I tried to use this to selectively send sheets within a workbook. No luck! What would need to be changed? TIA. As a background I have a spreadsheet with 57 sheets with names of town and I'd like to be able to select using this. Nothing like asking for the moon eh! <VBG |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing selective sheets within a workbook.
Ron,
For me the templates would be the best. I will be creating XL files for 57 people, each in their own sheet using a macro I located on the web, but... I would prefer to use the name of the Sheet rather than sheet2 or sheet10 or sheet56. In my case this will be city names and is easier to track. I could then set up one standard worksheet with this all encoded and then just run it. Could your template be changed to do this? Many thanks! Gary D "Ron de Bruin" wrote in message ... Hi Gary Install my Add-in http://www.rondebruin.nl/mail/add-in.htm You can select the sheets you want then Or use a template http://www.rondebruin.nl/mail/templates.htm Or use code http://www.rondebruin.nl/mail/folder1/mail3.htm Or http://www.rondebruin.nl/mail/folder2/mail3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... http://www.rondebruin.nl/mail/folder2/files.htm I like the Mail a different file or many files... I tried to use this to selectively send sheets within a workbook. No luck! What would need to be changed? TIA. As a background I have a spreadsheet with 57 sheets with names of town and I'd like to be able to select using this. Nothing like asking for the moon eh! <VBG |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing selective sheets within a workbook.
Hi Gary
You can enter the file name in the template Why not use this to send each sheet to the person you want http://www.rondebruin.nl/mail/folder2/mail5.htm Or http://www.rondebruin.nl/mail/folder3/mail5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... Ron, For me the templates would be the best. I will be creating XL files for 57 people, each in their own sheet using a macro I located on the web, but... I would prefer to use the name of the Sheet rather than sheet2 or sheet10 or sheet56. In my case this will be city names and is easier to track. I could then set up one standard worksheet with this all encoded and then just run it. Could your template be changed to do this? Many thanks! Gary D "Ron de Bruin" wrote in message ... Hi Gary Install my Add-in http://www.rondebruin.nl/mail/add-in.htm You can select the sheets you want then Or use a template http://www.rondebruin.nl/mail/templates.htm Or use code http://www.rondebruin.nl/mail/folder1/mail3.htm Or http://www.rondebruin.nl/mail/folder2/mail3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... http://www.rondebruin.nl/mail/folder2/files.htm I like the Mail a different file or many files... I tried to use this to selectively send sheets within a workbook. No luck! What would need to be changed? TIA. As a background I have a spreadsheet with 57 sheets with names of town and I'd like to be able to select using this. Nothing like asking for the moon eh! <VBG |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing selective sheets within a workbook.
It's obvious that I am not explaining myself too well much as you have tried
to help me Ron. <VBG So let me start over. I have an Access database and I have to be able to or I'd like to be able to email reports to 57 people in different parts of Manitoba Canada. I have tables that if they were sorted on City you might say each table would be like looking at 57 tables combined into one table. So I found - on the web - ExtractReps which takes one of my exported to Excel tables and from Sheet1 creates those 57 Sheets, each identified with by the city names rather than Sheet2 to Sheet57. So... I figured I'm almost there, all I really need is a simple macro that will create 57 emails, each with their own attachment. From the links that you have sent me I don't see that. I hope I didn't overlook anything Ron, I like the TestFile macro, except it doesn't handle my sheet names... or for that matter any sheets. Otherwise than that it could be set up once and all I'd have to do is add in the different XL worksheets or for that matter any file. I don't know if this helps you see what I'm struggling with or not. Here's hoping that you can help me. Regards, Gary Dikkema "Ron de Bruin" wrote in message ... Hi Gary You can enter the file name in the template Why not use this to send each sheet to the person you want http://www.rondebruin.nl/mail/folder2/mail5.htm Or http://www.rondebruin.nl/mail/folder3/mail5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... Ron, For me the templates would be the best. I will be creating XL files for 57 people, each in their own sheet using a macro I located on the web, but... I would prefer to use the name of the Sheet rather than sheet2 or sheet10 or sheet56. In my case this will be city names and is easier to track. I could then set up one standard worksheet with this all encoded and then just run it. Could your template be changed to do this? Many thanks! Gary D "Ron de Bruin" wrote in message ... Hi Gary Install my Add-in http://www.rondebruin.nl/mail/add-in.htm You can select the sheets you want then Or use a template http://www.rondebruin.nl/mail/templates.htm Or use code http://www.rondebruin.nl/mail/folder1/mail3.htm Or http://www.rondebruin.nl/mail/folder2/mail3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... http://www.rondebruin.nl/mail/folder2/files.htm I like the Mail a different file or many files... I tried to use this to selectively send sheets within a workbook. No luck! What would need to be changed? TIA. As a background I have a spreadsheet with 57 sheets with names of town and I'd like to be able to select using this. Nothing like asking for the moon eh! <VBG |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing selective sheets within a workbook.
Hi Gary
Why not insert the receivers mail address in every sheet in a cell you want (I use A1) You can hide it also if you want. You can use this then http://www.rondebruin.nl/mail/folder1/mail5.htm Or the Outlook version http://www.rondebruin.nl/mail/folder2/mail5.htm Both use the sheet name in the file name (you can change the file name) -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... It's obvious that I am not explaining myself too well much as you have tried to help me Ron. <VBG So let me start over. I have an Access database and I have to be able to or I'd like to be able to email reports to 57 people in different parts of Manitoba Canada. I have tables that if they were sorted on City you might say each table would be like looking at 57 tables combined into one table. So I found - on the web - ExtractReps which takes one of my exported to Excel tables and from Sheet1 creates those 57 Sheets, each identified with by the city names rather than Sheet2 to Sheet57. So... I figured I'm almost there, all I really need is a simple macro that will create 57 emails, each with their own attachment. From the links that you have sent me I don't see that. I hope I didn't overlook anything Ron, I like the TestFile macro, except it doesn't handle my sheet names... or for that matter any sheets. Otherwise than that it could be set up once and all I'd have to do is add in the different XL worksheets or for that matter any file. I don't know if this helps you see what I'm struggling with or not. Here's hoping that you can help me. Regards, Gary Dikkema "Ron de Bruin" wrote in message ... Hi Gary You can enter the file name in the template Why not use this to send each sheet to the person you want http://www.rondebruin.nl/mail/folder2/mail5.htm Or http://www.rondebruin.nl/mail/folder3/mail5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... Ron, For me the templates would be the best. I will be creating XL files for 57 people, each in their own sheet using a macro I located on the web, but... I would prefer to use the name of the Sheet rather than sheet2 or sheet10 or sheet56. In my case this will be city names and is easier to track. I could then set up one standard worksheet with this all encoded and then just run it. Could your template be changed to do this? Many thanks! Gary D "Ron de Bruin" wrote in message ... Hi Gary Install my Add-in http://www.rondebruin.nl/mail/add-in.htm You can select the sheets you want then Or use a template http://www.rondebruin.nl/mail/templates.htm Or use code http://www.rondebruin.nl/mail/folder1/mail3.htm Or http://www.rondebruin.nl/mail/folder2/mail3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gary J. Dikkema" wrote in message ... http://www.rondebruin.nl/mail/folder2/files.htm I like the Mail a different file or many files... I tried to use this to selectively send sheets within a workbook. No luck! What would need to be changed? TIA. As a background I have a spreadsheet with 57 sheets with names of town and I'd like to be able to select using this. Nothing like asking for the moon eh! <VBG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide unnecessary sheets when emailing to others | Excel Worksheet Functions | |||
| Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
| Split large sheet into several smaller sheets for emailing | Excel Programming | |||
| Emailing Sheets Code Edit | Excel Programming | |||
| Emailing Sheets | Excel Programming | |||
Hybrid Mode
