email multiple reports to multiple recipients

[slimjen]

All, Using access 2010. I've used code to send email to recipients. But I can not find how to send multiple reports to multiple recipients. Ex. I may have a table setup of recipients to send an email with a report attachment but all recipients may not receive the same report. Do I have to create separate module for each or can it be done in one module?? I was thinking I could do the with a case statement but could not find any examples. Thank you for your help in advance.

[burrina]

One approach is to store those Reports in a folder outside Access and then attach as needed.

HTH

[slimjen]

Ok. So do my code includes a case statement for each recipient to grab the correct file(s)? If there are about 20 or more this could quite long? Any shortcuts?

[burrina]

You save your Reports in whatever format you choose, then attach them to your email. Is this being done manually? If not, then this will get way tricky!
Google for more examples:

[slimjen]

Ok. I get that I save the files n a folder what I need is code to loop thru n grab the file or files for that person then open up an email to send then repeat the loop to continue to the next person. I'll google to see what comes up n the mean time. Thanks

[burrina]

What you are asking is kinda complex. Maybe a canned app such as one from http://www.fmsinc.com/MicrosoftAccess/email.asp would be your answer. Anyway, if not, maybe this will get you started. It can of course be modified to suit your needs.

Good Luck With Your Project!