Alternative Way to Send Report by Email?

[nick404]

Hi all,



I have been emailing .pdf reports from my database to place orders for various parts the company needs. I have simply been using the SendObject() method and it has sufficed, but I am wondering if there is a better way to send emails from Access?
SendObject has a lot of limitations that I do not like. Specifically, not being able to specify a From address and that irritating MAPI confirmation of "do you really want to allow this program to send an email on your behalf" message that, plainly, confuses new users.

Would using CreateObject(Outlook.Application) be a better route? Any other ideas and advice appreciated.

[pbaldy]

That would give you more control, but still throw the warning if you send directly. CDO would probably cover both bases, since it bypasses Outlook.

[nick404]

Thanks Paul, I had a feeling there was other methods but couldn't find anything other than sendObject.

In order to use the cdo I will need to code in all the information out the smtp server, correct? Everyone at the plant will still be using Outlook as their main source for sending/receiving mail, but this method will surpass the outlook confirmation?

[pbaldy]

Yes, you put in the server info (in my case it's an Exchange Server) and emails go directly to it rather than through Outlook. The downside is that items sent don't appear in Sent Items, so I often cc somebody. The upside is you can use whoever you want for the From.

[nick404]

Great! I am working on getting the module working, but I am having problems trying to find my server's port #... We use a company exchange server it appears, and nowhere in my account settings can I locate a port number. Am I looking in the wrong spot, or might I have to find the admin who sets up the mailboxes?

[pbaldy]

The argument for "smtpserverport"? I use 25 and it works with our Exchange server.

[nick404]

Set serverport to 25 and there was no issue.
Thanks for the help guys, works out well!

[pbaldy]

Happy to help!