Thanks for your reply ADezii. I am doing something similiar to that in the test database as a tempory fix but I think I like your idea better because it will look just like the automated result (when and if I can get it to work). I never thought of embedding it as an object. Good idea. Thanks!

Thank you for the reply. I cant believe I forgot to mention I am using Microsoft Access 2003. Yes, I can export the report in a number of formats including html. It doesn't look spectacular but it would be acceptable. I basically just need the missing link to attaching the specific attachment and using the report as the email body. If I find a solution other than here then I will be glad to share it. I can usually figure VBA out but the codes...

First, let me say that VBA is not my strong point but I have been bestowed with creating a duplicate database of a former employee who sabotaged the original. And everyday this isn't working is creating a ton of manual work for other people. I have managed to get the entire database working with the exception of the final step.

Basically, you click three buttons, the first button imports many text files using the Open File Dialog...