Problem Extracting DTS to Excel

HI,

I'm creating an Scheduled DTS to extract Sales data into Excel and Email the Excel sheet and I almost have it complete :) Apart of one small problem. (The bit I though would be easy).

The DTS is Emailing, scheduling and executing ok.

I have had to write a little bit of VBscript to cleardown the contents of the Excel fle before I begin loading the data each time, but when the data is loaded into Excel it does not start at the first Cell but maybe 700 lines down the worksheet

I think it is my VBscript that is the problem but I'm not sure. Has anyone else had problems like this?

Example

For Each Excel_WorkSheet in Excel_WorkBook.WorkSheets
If Excel_WorkSheet.Name = CStr(sSheetName) Then
Excel_WorkBook.Worksheets(sSheetName).Range
("A2:IV65536").ClearContents
Excel_WorkBook.Save
bFound = True
Exit For
End if
Nexti haven't looked into excel object, but can't you issue something like Excel_WorkBook.Home before you do Excel_WorkBook.Save?|||Have you tried deleting the range rather than clearing the contents ? Why do you need to do this ?

Problem emailing report

Hi All,
Below is an extract from my RSReportServer.Config file.
Can anyone see what the problem is with my configuration.
I get the following error in my subscription
"Failure sending mail: The server rejected the sender address. The server
response was: 550 Sender address is missing a domain "
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtp.registeredsite.com</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>pop.registeredsite.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Thanks
SanjeevThe from tag should include an email address. I used ReportingServices,
so for you the line would be:
<From>ReportingServices@.registeredsite.com</From>
This doesn't have to be a valid address.|||Hi Pete,
I have done as you suggested. Unfortunately, I just a get a different error
message now.
"The e-mail address of one or more recipients is not valid."
Did you get this as well before sorting the problem out?
Thanks
Sanjeev
"Pete" <prahalski@.hotmail.com> wrote in message
news:1131569084.930928.236010@.g43g2000cwa.googlegroups.com...
> The from tag should include an email address. I used ReportingServices,
> so for you the line would be:
> <From>ReportingServices@.registeredsite.com</From>
> This doesn't have to be a valid address.
>