Using OLE to connect to outlook allows you to set all of the properties of an email except for who the email is sent from. I need to customize this property so that when emails are sent to customers in my application I can specify whatever email address I want them to reply to. Any ideas? I use the following code to connect to Outlook:
oOutLookObject = CreateObject("Outlook.Application")
oEmailItem = oOutLookObject.CreateItem(0)
With oEmailItem
.Body = "Email Contents"
.To = "
Customer@Weissinc.com"
.Subject = "Order Confirmation"
.Send
EndWith