Comments by Central_IT (Top 25 by date)

The message I get is "A program is trying to automatically send an email on your behalf. Do you want to allow this? Yes or No"

The reason I am sending an email to myself is because I am running overnight jobs and want an email sent to me with certain messages etc.

Thanks for getting back to me. Unfortunately I get the error "Exception from HRESULT: 0x800A03EC" when I try and run this part of the code.

The array is as xlWorkSheet.Range("A2").Resize(30, 4690).Value = MyArray

Do you think this is an excel error?

MyArray is made up as follows 3 elements and say 1000 records

i.e. MyArray(3,1000)

Thanks for this code as well, this will help.

Thanks for this code, this will help.

Depending on the system date will be input automatically

Depending on the system date will be input.

Should have been 5 stars but not allowing me over 4

Thanks yet again for the required information. There is enough info there to solve my problem.

Thanks for getting back with a quick reply.
Your solution works perfect. Just a wee question,
How can you in a loop display the headings and then the data?

When I run the followiing I get the following error message

Incorrect syntax near '@SQL'. Expecting SELECT, or ')'

When I run the followiing I get the following error message

Incorrect syntax near '@SQL'. Expecting SELECT, or ')'

Thanks for the quick response. Your code works to a point.
I build a new datasource everytime I want a new report. When I run the code, it is still holding onto the old data in the MyDatasource and displaying. I think I want to flush the data in the previous datasource before populating the reportviewer. I hope this makes sense?

Thanks

Thanks for the information

A PDF is created when the users run a Crystal Report. This PDF is saved in a SQL Server table. When the user scans a document say via a scanner, it is created into a Tif file. I want all the files to be PDF going into the SQL Server table and not a mix. Basically I want to convert this scanned tif image into a PDF and then save into SQL Server table. A simple solution would be all scanned images to PDF but there could be the case the user does not change the setting etc.

Hi,
Thanks for getting back. In the example there is only one field "country". I have 2 fields that I want populate Allocated To and Sales Total. Any idea how I would add the extra field to get working.

Afraid that never worked. Even tried an earlier version of the project.

Tried it and it work. Thanks for the advice

Tried it and it work. Thanks for the advice