I have a large database (several hundred people) and I need to send an annual confirmation of the information that is in the db. In the past, we produced a printed report (several hundred pages) that was split, stuffed in envelopes and mailed (costly). The report was 1 page each, fairly complex with fields mixed with boilerplate, and a sub-report included on the page.
I now have an eMail address for most people in their person record. I'll will still use the printed report for those with no eMail, but want to automate an eMail function to send the others their info. The info needs to be in an editable form so they can mark up corrections and hit reply to send it back.
Since I've not done automated eMail before, I've been trying to read up on it, both in this forum and elsewhere. It seems there are two main ways, DoCmd.SendObject and CDO. There also seems to be two options for the data, entrained as body text, and as an attachment.
Several of you have experience in eMailing and I'd appreciate any advice on what methods make the best sense. Also if anyone has done this and wants to share their code, I'll be glad to plagiarize. ;-}
I've never had a problem getting the emails out, either in the body or as an attachment. I don't know about the "editable and send back bit" though. Of course you don't have that with printed reports now. I know 2007 added some kind of email form that might do this, but I have not tried it. This and the associated links should get you going with the other parts:
NTC, the square peg approach would be worse, IMHO, than the paper, stuff, mail approach now being used because each report is tailored with the recipients info.
Thanks, I've looked at granite and it has a lot of good info. I was hoping for a definitive this is better than that from someone but I know that is wishful thinking. I'm currently leaning to the entrained-in-body approach. Creating 200-300 files, one for each person, keeping track of them for attaching, and then deleting them, seems to make the attachment method less desirable. However, I'm not sure I understand the entire process for doing attachments to emails on a dynamic basis.
The first and more important question, is what eMail method to use: DoCmd.SendObject or CDO
One key difference between them is that SendObject will put the items in your sent items; CDO will not (unless I've missed a setting somewhere). I get around that by copying myself if I want to see evidence of it going out. Conversely, CDO will go around the Outlook security warnings, SendObject won't.