|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Emailing selective sheets within a workbook.
I can also change the template for you
Or add all the info in the macro See Example 2 http://www.rondebruin.nl/mail/folder1/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 |
Emailing selective sheets within a workbook.
Hey Ron,
I'm just getting back to this. The data comes from Access and there will be many tables that the user will ask to be subsetted and routed to any of 57 people. I don't know if you're familiar with EmaiSenate or EmailSenate2k, both Access programs that have the ability to route reports as an HTML attachment. If it wasn't for the fact that the reports get broken up into page one and two strangely I'd say it would be perfect as I could email reports as opposed to report content being exported to one Excel sheet and then thru macros getting routed. The 57 city table for lack of a better word is just one of a few that I envision being asked for. The table is a subset of the main table in my application. I have another table that contains those 57 cities which I would use for routing. I guess I am resisting ADDING 57 routing records to all of my tables that I would consider routable... <VBG... I don't know why; call it old programming habits from the mainframe days of 3 or more decades ago. <VBG Anyways I skimmed ahead and saw your offer Ron; I really appreciate all of your help. I will respond to your next question in that email. Thank you again so very much! Regards, Gary Dikkema "Ron de Bruin" wrote in message ... 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 |
Emailing selective sheets within a workbook.
Ron,
That SendMail doesn't work for me as I need to route each sheet and every sheet as it's own file. When I tested SendMail and selected all of the files it sent them all as one attachment. In my case - my needs are such - that each sheet will ALWAYS go to one city manager. So I need the ability to create a 'routing file' that will send from that one workbook 57 sheets as a separate workbook to 57 city managers. This is probably a very specific need that very few people would be looking for. Regards, Gary Dikkema "Ron de Bruin" wrote in message ... I can also change the template for you Or add all the info in the macro See Example 2 http://www.rondebruin.nl/mail/folder1/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 |
| All times are GMT +1. The time now is 03:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com