Dear All,
Please Help me , I need a VBA code to Put certain E-mail in From field before sending any E-mail Automatically
Dawy
Put E-mail In From Field
Hot Topic
Microsoft ISV
- Crying like a baby
- Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.
- Passing commands to unix from VBA EXCEL
- VBA Excel Module opening Access DB with Recordset
- Does KeyPress event trap "Backspace" key?
- Supported MS Access Versions
- What is an error 400?
- dim as new object at form level or just dim the variable
- Can you guys help me fixing the error?
- Program code fro sorting coloumns in a listbox VB Excel
Put E-mail In From Field
JamieHiggins
You can use the "SendOnBehalveOfName" property:
Sub MailMe()
Dim outApp As Outlook.Application
Dim outMail As Outlook.MailItem
Set outApp = CreateObject("outlook.Application")
Set outMail = outApp.CreateItem(olMailItem)
outMail.SentOnBehalfOfName = "It'sMe@mail.com"
outMail.To = "1@2.3"
outMail.CC = "4@5.6"
outMail.Subject = "Test"
outMail.Body = "This is a test mail"
outMail.Display
End Sub