Sending an email from Excel

[BigDelGooner]

Hi there - new member and my first post here.

I was wondering if there was a way to fill in the 'from' field as there is with the 'to' field when sending an email from excel vba.

Basically something like

ActiveWorkbook.SendMail
Recipients:="helpmeplease@stuck.com"
From:="MySharedMailbox"

Ideas anyone?

 

[RobbertH]

This will help you to do want you want

http://www.rondebruin.nl/sendmail.htm

 

[BigDelGooner]

Thanks for the quick reply.

I did see that earlier after a google search but couldnt find anything on changing the 'from' field (it is also probably worth mentioning that I am using excel 2002)

 

[spcalan]

This is what I use:

Private Sub SendToRockmart()
Set myOlApp = CreateObject("Outlook.Application")

Set MyItem = myOlApp.CreateItem(olMailItem)
With MyItem

.To = "NAME"
.Attachments.Add "ENTIRE URL of FILE"
.Subject = "SUBJECT LINE"
.Display
.Send

End With
End Sub

 

[BigDelGooner]

Thanks for the reply spcalan but this option still doesnt let me populate the 'From' field in an email.

I have access to a few mailboxes at work and need to populate the 'From' field with the string "Group-Modelling"

Any ideas?