Recent content by GettingDone

Pbaldy, No worries, I got around the sent email box by changing my user profile in outlook to only show one email box. Never did get around the outlook security warning without errors in the whole process. If i need help in the future should I begin a new thread?

One more issue: I have multiple email boxes set up in outlook. I want to select which box the end-recipients recieve the file from. I added these following lines to the code, but it still sends from my default mailbox.... Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sMailFrom As...

Pbaldy, Everything works perfect now with two different queries. I was also hoping to get around the outlook security warnings (when sending from access). I have 500 recipients getting customized reports and it would be painful to have to click "yes" for each email. I tried a very...

That was something I changed to run some more tests, it was [UnboundCode]. That is a good thought, I will experiment with the changing the recordset and adding another query, possible one that pulls just "Code" and "Email" from the orginal data table. I will post any issues that arise Your...

I think it errored because it was looping, the query cant pull from the box it is sourcing in the code.

Thanks for the response! When putting the criteria in to my query it returns an error. This makes sense because no values are entered in the the unbound text box: [UnboundCode] My report right now is 3 pages, for the 3 records in the query. To make this process loop correctly and only send...

I am attempting to learn more about Automatically generating e-mails from a report. I used the above script as a base line but am still encountering a similar error to that "rnickels" fixed. My loop is working correctly in the sense that it is looping through and sending the report via e-mail to...