You are going to have to digitally sign the project on each PC that the macro is used on to avoid the macro enabling issues and retain security -http://www.gmayor.com/create_and_employ_a_digital_cert.htm



While you can check if the To is a particular distribution list
e.g. If .To = "Bob"
I don't think you can check if To is any old distribution list without additional software - see http://www.outlookcode.com/d/code/promptdl.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

For the moment I'm okay without the digital signatures and just allowing the user to manually allow the macro to run. I did a little research on the signatures and the process doesn't seem too onerous.

For my uses checking for a very specific distribution list is what I need. That is "Bob" is the distribution list, and "Personal Information Bob" is the name of the attachment and in the Subject line. I want all three to match up before the email is allowed to be sent.

Thanks,
Andrew