Phil Parkin (11/15/2011)

---

I'm still a little puzzled.

I create a new Excel Workbook from scratch.

I import the Pivot Tables into 7 different sheets and the size grows to 116MB even though...

I believe that I saw an old post with an old price but the price that you quoted is what I saw this past weekend on your site.

Thank you.

Phil Parkin (11/15/2011)

---

Welsh Corgi (11/7/2011)

---

I'm loading multiple Sheets into an Excel File from SQL Server.

The macro listed below will reset the used cell ranges and should reduce the File Size....

I found the following, testing from my PC:

REATE PROCEDURE sp_SMTPMail

@SenderName VARCHAR(100),

@SenderAddress VARCHAR(100),

@RecipientName VARCHAR(100),

@RecipientAddress VARCHAR(100),

@Subject VARCHAR(200),

@Body VARCHAR(8000)

AS

SET NOCOUNT ON

DECLARE @oMail INT --Object reference

DECLARE @resultcode INT

EXEC @resultcode = sp_OACreate 'CDONTS.NewMail',

@oMail OUT

IF @resultcode...

CozyRoc (11/14/2011)

---

Using Excel automation API is not very good idea for many reasons.

If you can use third-party solutions, check the commercial CozyRoc Excel Task. It supports deletion of columns and/or...

I may have to go with a simpler solution.

The cursor is almost done, just need to add the dp_send_dbmail part.

I will revisit Lowell's solution when I go back to the...

Ninja's_RGR'us (11/14/2011)

---

Welsh Corgi (11/14/2011)

---

Ninja's_RGR'us (11/14/2011)

---

SSRS + subscriptions could work if you have enterprise.

If not send an html e-mail and use code to calculate the correct headers for the code and...

Ninja's_RGR'us (11/14/2011)

---

SSRS + subscriptions could work if you have enterprise.

If not send an html e-mail and use code to calculate the correct headers for the code and you'll be 100%...

I'm sorry google what site?

Ninja's_RGR'us (11/14/2011)

---

SSRS + subscriptions could work if you have enterprise.

Unfortunately no enterprise.:laugh:

If not send an html e-mail and use code to calculate the correct headers for the code and you'll...

I should have been more clear and not assumed that everyone was familiar with the US Postal Service (USPS) Zip Code convention.

The USPS has 5 Digit Zip Codes and there...

Just got this IM:

so to summarize the requirements, we just need to generate an email to each agency on the list with their policy count to date.

I...

I'm sorry, I did...

Thank you for the responses.

Currently I'm using a CASE Statement to get PreviousMonthNumberSales,

PreviousMonthSumSales,TwoMonthsPriorNumberSales,

TwoMonthsPriorSumSales, etc going back 5 months.

The original requirement was to generate a Report for each of...

Thanks for the tips everyone.