Help! Subject line on report sent via e-mail

[FC]

I have a form set up with multiple option buttons for the user to select a report to e-mail. The final option button is for the user to select "all" reports to e-mail. I am using Select Case and then on the "all reports" case, it has a DoCmd to open each report one at a time and send each via email as a snapshot. (I can't find a way to send multiple reports on one e-mail). The problem is, the user wants to attach a new subject line each week when the report is sent. I don't want it to stop on each report (the reports take a long time to run). I was thinking I could add a field to the form for the user to type in the new subject line for that week and have the code referenct that field, but I don't have a clue as to how to begin. Anyone with any ideas?? Thanks!!

 

[KevinM]

I can help you with your subject line but unfortunatley not with your multople attachments (I wouldn't mine knowing how to do that myself !).

on your form create a textbox called txtSubject.

On the Docmd.SendObject line, replace your existing subject with txtSubject (no quotes).

You can do the same with the body message if you like.

That's it.

HTH

 

[FC]

Kevin,
You are a genius! This worked like a charm and was exactly what I needed! You just saved me a ton of time. Thanks!