Auto E-Mail

[Guest_imported]

Hi all,

Can anyone help me on the following.

I would like to know if there is a VB Macro that would enable me to schedule a report on BCA, then, when the report has refreshed, BCA would email it out via Lotus Notes


BCA runs on Windows NT, and Business Objects is version 5.1

IF anyone can help it would be much appreciated

 

[rob]

I have built a VBA routine that uses the jmail freeware dll to mail report via our SMTP mail gateway. It works very well. We looked originally at using a MAPI compliant method, but found that jmail was much easier to implement. If you have an API to lotus notes (and I seem to remember there are some), then you can do the same thing. However, if your company/site has the ability to SMTP, I'd go the jmail route. Jmail dll can be found at:

http://tech.dimac.net/

Cheers,
Rob.

 

[rob]

I have built a VBA routine that uses the jmail freeware dll to mail report via our SMTP mail gateway. It works very well. We looked originally at using a MAPI compliant method, but found that jmail was much easier to implement. If you have an API to lotus notes (and I seem to remember there are some), then you can do the same thing. However, if your company/site has the ability to SMTP, I'd go the jmail route. Jmail dll can be found at: tech.dimac.net

Cheers,
Rob.

 

[rob]

I have built a VBA routine that uses the jmail freeware dll to mail report via our SMTP mail gateway. It works very well. We looked originally at using a MAPI compliant method, but found that jmail was much easier to implement. If you have an API to lotus notes (and I seem to remember there are some), then you can do the same thing. However, if your company/site has the ability to SMTP, I'd go the jmail route. Jmail dll can be found at: tech.dimac.net

Cheers,
Rob.