mail multiple recipients (1 Viewer)

[Gismo]

Hi All,

I am using EMailDatabeseObject in a on click event macro
I need to mail to multiple recipients based on a query

I tried to use builder to link the query to the recipient "To" line but that apparently does not work that way

 

[arnelgp]

you can use the VBA equivalent:

docmd.SendObject

 

[Gismo]

you can use the VBA equivalent:

docmd.SendObject

I have no idea how to use the sendobject to include multiple recipients, attach a report and a customized message linked to multiple tables
i managed to get it working with a emaildatabaseobject macro

 

[Uncle Gizmo]

If you are emailing a dynamic report, a report with changing data, data which changes for each recipient, then take a look at my blog here:-

Generate Multiple Reports - Nifty Access

Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...

www.niftyaccess.com

At the bottom of the blog page is a set of extra, useful links. One of them is to Gina Whipps website where she demonstrates how to email the created reports. But you have to create the reports in the first place, hence the above code.

 

[Gismo]

If you are emailing a dynamic report, a report with changing data, data which changes for each recipient, then take a look at my blog here:-

Generate Multiple Reports - Nifty Access

Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...

www.niftyaccess.com

At the bottom of the blog page is a set of extra, useful links. One of them is to Gina Whipps website where she demonstrates how to email the created reports. But you have to create the reports in the first place, hence the above code.

unfortunately the page can not be found

 

[Uncle Gizmo]

unfortunately the page can not be found

Strange? It works for me in incognito mode...

I've recently added a plug-in that blocks some IP addresses, I wonder if it's misbehaving?

 

[Gasman]

Works fine for me?
Is this the one Tony?

Access Diva Send eMail to Multiple Recipients

Access-Diva provides custom databases using Microsoft Access utilizing SQL Server when called for.

www.access-diva.com

 

[Uncle Gizmo]

Is this the one Tony?

I reckon so Paul...

A very nice blog from Gina. .