Ok, I've got everything working however when I get to the final step the e-mail doesn't send automatically. It stays in the Outlook window and I have to click send yet your code shows that it should send automatically and close. Not sure why but can you shed any light on what may be wrong here...
Ok thanks I had a feeling it might be something like that. So I set a field named EMailFlag as a yes/no box
and have a seperate field containing the e-mail address?
Could you give me an idea of the fields to implement in a simple e-mail table test this out so it works without having to change...
I've tried testing the code. I created a new database with a table called "tble-mails" and included one field with 10 e-mail addresses. The code works fine for entering the message subject line, the message text file, the message attachment however I then get a run-time error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.