wolf.stalker
05-04-2010, 03:44 AM
hey all. i have a chunk of code that works great, but am tying to modify one last bit.
I run a macro daily that process a report, then sends it out to a bunch of different folks. the problem is they always email me back directly with questions instead of my group :banghead: .
Set objol = New Outlook.Application
Set objmail = objol.CreateItem(olMailItem)
With objmail
.From = "tvm2@here.com" '(i know this dosen't work...just using for illiustration becasuse i am not sure how else to make this work!")
.To = "william@here.com"
When i normally send out an email this is the header you would see. in other words, SAT - VM Distribution = tvm2@here.com and william = william@here.com
William; on behalf of; SAT - VM Distribution
i want to send it from tvm2 on my behalf. any ideas?
I run a macro daily that process a report, then sends it out to a bunch of different folks. the problem is they always email me back directly with questions instead of my group :banghead: .
Set objol = New Outlook.Application
Set objmail = objol.CreateItem(olMailItem)
With objmail
.From = "tvm2@here.com" '(i know this dosen't work...just using for illiustration becasuse i am not sure how else to make this work!")
.To = "william@here.com"
When i normally send out an email this is the header you would see. in other words, SAT - VM Distribution = tvm2@here.com and william = william@here.com
William; on behalf of; SAT - VM Distribution
i want to send it from tvm2 on my behalf. any ideas?