Recent content by Russell Grice

CDONTS This is the format for a CDONTS email. <% Dim MyMail Set MyMail = Server.CreateObject("CDONTS.NewMail") MyMail.From = "justme@myaddress.com" MyMail.To = "friend1@address1.com;friend2@address2.com" MyMail.Cc = "friend3@address3.com;friend4@address4.com" MyMail.Bcc =...

Didnt look into doing attachments myself but think the code thats on this page may help you...? http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/32/pid/329/qid/473564 cheers Russell

How would an order change ? If this is something trappable like a button click then you could write some code in the onclick event of that button to send your email. You can send email at least three different ways from Access. You can use the DoCmd statement: DoCmd.SendObject , , , strTo...

Microsoft Knowledge Base article I got the idea/code from. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q286431

Finally got it working !! Added in references for CDO libraries and ActiveX library(although not sure if thats needed) nicked some code from MS site. Public Function SendEMail_CDO(strFrom, strTo, strCC, strSubject, strBody) Dim mail Dim config Dim fields Set mail =...

Thanks for your reply. As I've said further up the page, I've tried this, it works but I get the security message 'A program is trying to send an email on your behalf...' or something like that. You then have to authorise each email that gets sent which is a bit of a pain. Which Is why I wanted...

Yeah thats fine, my To: string is built up from an email address field, I loop through a recordset adding to the string dependant on a number of criteria. My main problem with using the DoCmd is that to send from a different user (which I have to do) I have to wait for the email to be created...

Take it using the DoCmd you cant specify a different user to send the mail from. Such as: Set MyOutlook = New Outlook.Application Set MyMail = MyOutlook.CreateItem(olMailItem) MyMail.SentOnBehalfOfName = "some1@somewhere" Until you get the mail created for you and on screen. Or can you..?

Thanks for that ! It works fine, but still requires user intervention. Which I would like to avoid, if possible.. I may be able to get our email guru to change the security setting on our exchange server to allow MS Access to send email without confirmation being needed.. Thanks again. R

Hi, Im pretty new to VBA development and would like a little help ! Trying to send an email after a button on a form is pressed. Have a module with email code in it: Set MyOutlook = New Outlook.Application Set MyMail = MyOutlook.CreateItem(olMailItem) MyMail.SentOnBehalfOfName = strFrom...