Will it still send to 1 email address that you hard code? Can you post the db after removing anything sensitive but leaving enough to demo the problem? I use 2002 also as my sig states. What email client do you use? Do you have all of your references?
I am probably making progress. I changed our field to hard coded string and still get the same error so it is probably some other argument of the SendObject causing the problem.
Works now Had to flip 2 around to....
DoCmd.SendObject acSendReport, "rptNewJob", "SnapshotFormat(*.snp)", _
EmailList(), "", "", Me!JobDescription, "The message", False, ""
It was putting the Me!JobDescription in the BCC field.
Looks like things were a bit off in my original... Strange it was working before the function was added.
But again, thank you very much for putting the function together for me. Time for me to go back to my VBA book and learn more! I'm reading "Beginning Access 2000 VBA" seems good... Finished the first 4 or 5 chapters (twice) Took a trip to Canada and got side tracked.... This lets me know I need to get back to it!!