Emailing Reports Based off of Criteria

[mlr0911]

Hello all,

I am trying to send a report to different recipiants based off of their email address. This report would only show information pertaining to them and no one else.

Does anyone have any idea how I can do this? I have tried using SendObject but as you know, it will send the entire report only and not exclude anything.

Desired Results:

Matt has 3 accounts under his email address

Jeremy has 4 accounts under his email address

The current report that would be sent to these two gentlemen would have both data on it.

I need to only send Matt's information to him and Jeremy's information to him.

---------and btw, I'm having other software kicking this database off, so no user input will be allowed; basically, the database will "open" and auto run sending the reports to everyone.

Thanks for your help

 

[pbaldy]

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

 

[mlr0911]

pbaldy,

Thanks for your reply, i don't see how this code can help me. since I'm not using a form for anything.

 

[pbaldy]

Then use a global variable instead.