Hi!
Finally after a long search for an appropriate way of sending Emails from Access I've found the code provided by DougP on these pages here.
As my application should be able to create several emails in "one go" (different lists are sent to the users in another table) this code is working but one thing is really annoying if you have more than 5 users/Emails generated:
The Email-Window remains open! Just imagine what your screen looks like if you have 250 Emails generated...
How can the code be changed, so that the Email is sent without shhowing up on the screen similar to the DoCmd.Sendobject acSendObject ,"",acFormatTXT,"recipient", "Subject", "Text", False <- ?
Thanks for any help!
Finally after a long search for an appropriate way of sending Emails from Access I've found the code provided by DougP on these pages here.
As my application should be able to create several emails in "one go" (different lists are sent to the users in another table) this code is working but one thing is really annoying if you have more than 5 users/Emails generated:
The Email-Window remains open! Just imagine what your screen looks like if you have 250 Emails generated...
How can the code be changed, so that the Email is sent without shhowing up on the screen similar to the DoCmd.Sendobject acSendObject ,"",acFormatTXT,"recipient", "Subject", "Text", False <- ?
Thanks for any help!
An old PICKer, using Access2000