I tried to find a post that already was created (in this year) for this type of issue. If I placed this in to the wrong thread please move it to the proper place.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I have gone though a lot of the postings about emailing though Excel (2003). The issue is that I am a novice. I do not know how to combine the macros needed to do what I would like to do.
<o> </o>
I have a spreadsheet with four tabs.
<o> </o>
Tab 1:
This sheet gets data from a SQL Database. Each morning a standard SQL Query is run to get data form the database. It is formatted to return five columns. I copy the results and paste it in to the sheet (A2) A pivot table is already set up and just needs to be refreshed. I would like the pivot table to refresh once the data is entered if possible. I have been told that Excel can actually run the SQL Query for me and insert the data (maybe a possible enhancement in the future).
<o> </o>
Tab 2:
I have to enter in text that comes to me in email (text file) every morning. I have to open the text file and cut and paste the data into the second tab (minus the header row). After placing the data in to cell A2, I have to refresh the pivot table on the same tab. If this tab has more than 15 rows I need to color code the tab. The color is yellow. If the rows go past the 45 rows the tab color as red. I would like to have the pivot table refresh once the data is entered.
Tab 3:
On this sheet I have a three pivot tables that need to be refreshed (again I would like to have them refresh automatically). This sheet is just a summary page. This sheet gets emailed (two of the three pivot tables) to a group of people. I would like to have a way to click on a button and the two pivot tables get emailed in a formatted view inside outlook 2003 as one email. The format view needs to have one pivot table listed then the next pivot chart list below the first. I need to have a blank space between each pivot chart to write comments if needed. The first pivot chart (upper left corner) starts in cell AM3, the next one starts in cell N3. Each Pivot chart can be varying in size. The email needs to have a subject line. The subject line is already created in cell N1 of sheet three. Once the email is sent I would like for the excel spreadsheet to be saved on a network share. Saved file needs to be formatted this way “{text}_date”. The date format is yyyymmdd, and for the day before the day the report is emailed.
<o> </o>
Tab 4:
This is the list of people that need to be in the TO and CC line of the email. Also the email needs to come from a different mailbox that I am apart of. So the From portion of the email needs to be different from mine (I have access to the other email account). I have each name in columns listed by From: (cell A2), To: (cell B2:B6), CC: (cell C2:C3)
<o> </o>
Now, this is a huge list of things to have excel do. I know that I may be asking for the Moon on this one. I just am having huge issues with getting excel to perform any part of theses “Wish List” items to function at all. As I stated I am a novice and I am not having any luck getting this done. This maybe something excel just cannot do.
<o> </o>
Any help that anyone gives will have my thanks and gratitude.
<o> </o>
Reference Items I have tried to use.
<o> </o>
http://www.rondebruin.nl/sendmail.htm<o></o>
http://www.mrexcel.com/forum/showthread.php?t=76983
http://support.microsoft.com/kb/816644
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I have gone though a lot of the postings about emailing though Excel (2003). The issue is that I am a novice. I do not know how to combine the macros needed to do what I would like to do.
<o
> </o>I have a spreadsheet with four tabs.
<o
> </o>Tab 1:
This sheet gets data from a SQL Database. Each morning a standard SQL Query is run to get data form the database. It is formatted to return five columns. I copy the results and paste it in to the sheet (A2) A pivot table is already set up and just needs to be refreshed. I would like the pivot table to refresh once the data is entered if possible. I have been told that Excel can actually run the SQL Query for me and insert the data (maybe a possible enhancement in the future).
<o
> </o>Tab 2:
I have to enter in text that comes to me in email (text file) every morning. I have to open the text file and cut and paste the data into the second tab (minus the header row). After placing the data in to cell A2, I have to refresh the pivot table on the same tab. If this tab has more than 15 rows I need to color code the tab. The color is yellow. If the rows go past the 45 rows the tab color as red. I would like to have the pivot table refresh once the data is entered.
Tab 3:
On this sheet I have a three pivot tables that need to be refreshed (again I would like to have them refresh automatically). This sheet is just a summary page. This sheet gets emailed (two of the three pivot tables) to a group of people. I would like to have a way to click on a button and the two pivot tables get emailed in a formatted view inside outlook 2003 as one email. The format view needs to have one pivot table listed then the next pivot chart list below the first. I need to have a blank space between each pivot chart to write comments if needed. The first pivot chart (upper left corner) starts in cell AM3, the next one starts in cell N3. Each Pivot chart can be varying in size. The email needs to have a subject line. The subject line is already created in cell N1 of sheet three. Once the email is sent I would like for the excel spreadsheet to be saved on a network share. Saved file needs to be formatted this way “{text}_date”. The date format is yyyymmdd, and for the day before the day the report is emailed.
<o
> </o>Tab 4:
This is the list of people that need to be in the TO and CC line of the email. Also the email needs to come from a different mailbox that I am apart of. So the From portion of the email needs to be different from mine (I have access to the other email account). I have each name in columns listed by From: (cell A2), To: (cell B2:B6), CC: (cell C2:C3)
<o
> </o>Now, this is a huge list of things to have excel do. I know that I may be asking for the Moon on this one. I just am having huge issues with getting excel to perform any part of theses “Wish List” items to function at all. As I stated I am a novice and I am not having any luck getting this done. This maybe something excel just cannot do.
<o
> </o>Any help that anyone gives will have my thanks and gratitude.
<o
> </o>Reference Items I have tried to use.
<o
> </o>http://www.rondebruin.nl/sendmail.htm<o
></o>http://www.mrexcel.com/forum/showthread.php?t=76983
http://support.microsoft.com/kb/816644
