I currently am using code I received from one of the threads for auto emailing using ACCESS. Everything seems to be working. I am creating a session using an MAPI VBA code. Is there any way to change/override the FROM name? It is currently picking up the user who is running the application. I am sending out invoices, I want to use the company name, not the person running the application.
Some of my code looks like the following. Looking for something like objMessage.from = or whatever. Is there a list of all the options for this stuff somewhere's?
Set objMessage = objSession.Outbox.Messages.Add
'Set the properties of the message object
objMessage.Subject = "Company message" " & Me.tblohb_ID
objMessage.Text = "Per your request, this invoice is being emailed automatically
'Add a recipient object to the objMessage.Recipients collection
Set objRecipient = objMessage.Recipients.Add
'Set the properties of the recipient object
objRecipient.Name = Me.PC_CUST_EMAIL
objRecipient.Type = mapiTo
Thanks for everyone help.
Some of my code looks like the following. Looking for something like objMessage.from = or whatever. Is there a list of all the options for this stuff somewhere's?
Set objMessage = objSession.Outbox.Messages.Add
'Set the properties of the message object
objMessage.Subject = "Company message" " & Me.tblohb_ID
objMessage.Text = "Per your request, this invoice is being emailed automatically
'Add a recipient object to the objMessage.Recipients collection
Set objRecipient = objMessage.Recipients.Add
'Set the properties of the recipient object
objRecipient.Name = Me.PC_CUST_EMAIL
objRecipient.Type = mapiTo
Thanks for everyone help.