EMailing Reports From Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JeffG - 19 Jun 2007 21:41 GMT

I know this may have been asked, but after looking on the Internet, I need
some clarification...Can reports be emailed from Access? The environment
that I have is as follows...WinXP SP2, Outlook 2002, 2003 or 2007, all with
SP's applied. I would be using Leban's method of exporting the reports to
PDF format.

From what I've read, it's a security risk. I understand that, but I've also
seen some other things that suggest that maybe it can be done via VBA.

Any help would be appreciated.

Thanks

Jeff G

Reply to this Message

Douglas J. Steele - 19 Jun 2007 21:50 GMT

It's a security risk only because Outlook (and other e-mail clients) have
been patched not to accept automation without confirmation that it's okay.
(Actually, Outlook 2007 can recognize that it's being automated from a
trusted source, so it won't prompt you). Other than that, there's no
security risk that I can see.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I know this may have been asked, but after looking on the Internet, I need
>some clarification...Can reports be emailed from Access? The environment
[quoted text clipped - 11 lines]
>
> Jeff G

Reply to this Message

JeffG - 19 Jun 2007 21:57 GMT

So, the code should still work and allow the emails to be processed?

> It's a security risk only because Outlook (and other e-mail clients) have
> been patched not to accept automation without confirmation that it's okay.
[quoted text clipped - 17 lines]
>>
>> Jeff G

Reply to this Message

Douglas J. Steele - 20 Jun 2007 02:20 GMT

I see no reason why not.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> So, the code should still work and allow the emails to be processed?
>
[quoted text clipped - 13 lines]
>>> also seen some other things that suggest that maybe it can be done via
>>> VBA.

Reply to this Message

dbahooker@hotmail.com - 20 Jun 2007 06:50 GMT

it's NOT a security risk; kid

you should be using Access Data Projects and xp_sendmail

it is practical to make a single SQL Server secure for email purposes.
it is not practical to do it on every users' desktops

On Jun 19, 1:50 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

> It's a security risk only because Outlook (and other e-mail clients) have
> been patched not to accept automation without confirmation that it's okay.
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Reply to this Message