That worked. So if you are doing a variable, you don't need the single quotes. When you are hardcoding it, you do need the single quotes.

Thanks...

Thanks for your time and pointing out the mismatch. I also changed the statement to local temp tables. I changed the mismatch, but that didn't resolve it.

Yes, I'm...

All my files that I'm attaching are < 200k, but I did bump up the file size to 5mb. The fact that I can hardcode all these files and...

Drew,

It's in 2 tables. And it's not my design, I just have to live with it. Thanks - I'll check this one out.

Thanks. Let me chew on that and see how I can incorporate it. I understand the concept, though. Thanks again.

Okay. Thanks to both of you for your input.

Thank you for your help with this. If I (system admin) create a subscription to go to them, is there a way for me to assign that subscription to...

Hello.

Did you ever figure out how to get this to work? I'm looking to do the same thing - have a link to where the person can open a...

That's good stuff. Thank you, Ian!!!

I've never used those commands before. Let me read up on them and I'll get back to you if it doesn't make sense. Thank you for your time.

Lowell (6/23/2010)

---

the secret is to use cid:attachedimage.gif for the source file.

here's a setup and working example:

I'm attaching the results of a query, and i copied the SQl server logo to...

Robert Cary (6/22/2010)

---

Keep in mind that most email clients do not automatically load images in emails for privacy reasons. I expect that isn't the issue, but I wanted to mention...

This is going externally - it's going out to our customers. I want to put our logo at the top of the email. Right now, it's blank.

That would make too much sense. That worked. Thanks!

Thank you very much. That worked.