Hi rdouglass,

my understanding is that the xp_sendmail sp would require "SQLMail" to be configured which depends on an Outlook client being configured and installed on the SQL server and the...

Thanks GSquared, only just read your post again very useful for the reports I am generating.

Thanks both.

thanks Dave for your rapid reply.

All sorted now!!

:hehe:

hi guys,

sorry for delayed reply only just got round to tested and implementing it, yes it worked thanks really appreciate it cheers.

I used the PATINDEX way, seemed a little easier.

Thanks...

Hi Guys,

back already!!!!!

Right.... i got the xp_sendmail function working and have started to have a play with the CDONTs functions which to my surprise I have managed to do and...

the data that is being stored is actually house numbers with street names so it could be...

cheers for the help, will have a play and let you know the outcome.

thanks again

Yeah I think i will stick to the xp_sendmail function for now as it seems to be a bit quicker and easier to use. Will defo read up on it...

And lastly.. i promise

is there a way to make the email being sent using the guidelines above in HTML format? and if so how?

Thanking you!!!!!

Thanks to everyone for their help, all working now.

😀

Thanks for the help,

I have managed to install an outlook client on the server and restarted the services and the above code works however it attachs the query as a...

Thanks for this,

I have used the query below:

EXEC master.dbo.xp_sendmail

@recipients = N'name@domain.com',

@query = N'EXEC ComSys..RPT_3_DailyEmail ''17-oct-2008''',

@subject = N'SQL...