Hi Phil

Thanks for your quick reply.

The 'LongDescription' column is Text and allow Nulls. I changed my destination table to match, but no change in the outcome.

Many thanks

Paul

Thanks, Markus.

I don't know how I didn't spot it in the Windows section.

I'm grateful for your help.

Paul

Thanks, Chris

I've got it working now - after a fashion...

My sp used the parameter to create a temp table, the values of which were returned and output to Excel. ...

Hi Danbarua

Many thanks for sending this. It looks very good. Email is working fine at the moment, but I'll give this a try and see if I can...

Hi Seth

I have tried to achieve this before - without a great deal of success. I'll work through, as you suggest, and see if I can make it happen...

Hi Seth

Could I pick your brains a little more..?

If I wanted to batch update an oracle table from a SQL Server 2000 table, joined on an id field and updating...

Hi Seth

It's the end of a long day. Your code works fine...

I can now go home in peace. Brilliant!!

Very many thanks

Paul

Hi Seth

This appears to work, however returns the message:

'The command(s) completed successfully'

rather than '1 row affected'. I've checked several ways, and the update hasn't been performed. However,...

Hi Seth

Thanks a lot for replying. Yes, I have been printing @sql. However, like an idiot, I've got the error messages above the wrong way around....

Hi William

That's great. I very much appreciate your help and support.

Many thanks

Paul

Hi Vic

I went in and tried again this morning on the XP machines. Low and behold it worked. I didn't change any code. I always find this...

Hi Vic

Yes I generate strings to replace the inserts. Unfortunately it still doesn't work on the organisations XP computers with Access 2003 and all other applications 2007. It...

Dear All

Thanks for your great responses.

jfmccabe,

I have just tried your code:

Dim olApp As Outlook.Application

Dim objMail As Outlook.MailItem

Dim objAttach As Outlook.Attachments

Set olApp = Outlook.Application

'Create e-mail item

Set objMail = olApp.CreateItem(olMailItem)

objMail.To...

Thanks, Chris

This definitely turned out to be the problem. Chris Quinn pointed it out earlier - though I should of thought of it myself, because it's such a logical...

Thanks, Vic

Good to know that I'm not the only one with these problems. I would have though that if Microsoft had fixed this, it would be in an update...