Include Outlook signature when sending reports from Access

[Glenley]

I'm trying to figure out how to include my custom Outlook signature in emails when sending reports directly from Access. The info we sometimes send falls under HIPAA guidelines and we have confidentiality statements in our email signatures but when sending directly from Access it doesn't include the signature. I'm not using any automated emailing or any VBA whatsoever concerning the emails. I'm simply emailing reports as a PDF document

[Gicu]

So is it solved or are you still looking for help with this? How do you

simply emailing reports as a PDF document

? Using a macro or Docmd.SendObject (I guess a macro as you mention not using VBA)? I'm afraid that without VBA you will not be able to accomplish that, but with VBA should be very easy. Usually all it takes is to use Outlook automation to create the message, attach the PDF (you need to use Docmd.OutputTo first to save it as a PDF somewhere) and use .BodyHtml for the message body which should include the signature. There are many threads in the various forums on this:
https://stackoverflow.com/questions/...ure-in-outlook
https://www.tek-tips.com/viewthread.cfm?qid=1774207
Cheers,

[Glenley]

My bad, I kind of found a solution but it was so simple I'm a little embarrassed that I had to ask. You simply have to manually insert your signature when your Outlook compose emaill window pops up. I'd still like to know how to have it do that automatically. I've noticed that a ton of people have asked this same question all over the web and every solution I've found has involved VBA. I have no problem using VBA but this isn't a situation where I'm using a command button or anything, just using the email command on the ribbon

[Welshgasman]

If you use automation, then displaying the email initially inserts your signature I believe?

I actually split the email template, between header and signature, inserted my html code and then concatenated it all back, as I did not want to have to display all emails and press send.

However automation is required to do that.

Edit: I seem to recall that any images in the signature did not work, but that was not a problem in my case.

[Micron]

I have no problem using VBA but this isn't a situation where I'm using a command button or anything,

If you can do this from a form, should not be hard to run code. If you like the ribbon action, you could customize your ribbon to run your own procedure, or perhaps a custom context menu (right click menu).