Jack, thanks for the quick reply. Do the extended SProcs that ran on V7 and 2000 run on 2005?

Also, I've never done any CLR programming. Any pointers on...

You can also do this from VBA. I do it all the time. I keep a list of tables to link inside the Access application. If I...

Good question Jack. The front end application is already written in Access. Using DB Mail seemed like the easiest way to send this type of EMail automatically -...

The EMail is not being composed by the user. They want to be able to click a button in the front end program and automatically send a PDF file...

Thanks Guys,

I'm afraid the multiple profiles will be difficult for my client to maintain. They seem to have people come and go and they want the the Reply...

I've done this before. Just create the columns to export as Jeff wrote and export those to the other application. That way you don't mess up your own...

Jeff,

Great post. I'd forgotten about that particular post of yours. I've actually been using tally type tables for dates for years but had forgotten how useful they can...

Thanks guys,

It sort of points to some sort of SPAM blocking on the SMTP server we're using. I'll get it sorted out with them.

Todd

Mani,

I already tried that.

Todd

You could try something like:

WHERE CHARINDEX(',' + CONVERT(VARCHAR, ID) + ',', @Var) <> 0

If the passed string didn't start and end with a comma you'd have to put one there...

We're not using Exchanger server. Just POP-3 and SMTP hosted somewhere else.

You think it's SPAM blocking by the hosting service?

Todd

Thanks Matt. I'll just have to create one off to the side to play with the new features.

Todd Fifield

Matt,

Thanks. I'm going to try it. I'd forgotten about these features since I'm mostly dealing with databases with compatibility mode 80. I keep getting burned trying to...

It looks like you have 1 too many single quotes in:

FROM ''' + @DataFileName + '''

I find using several single quotes together very hard to eyeball. ...

I'd like to see how that's done exactly. This is for a one to many relationship between Customer and CustomerNotes? There could be zero or more notes per...