Using VB, specific cell data into email subject
 

Using VB is it possible to use specific cell data and import this into the
subject field of an email

Can easliy create code to email the excel document succesfully, but need to
grab certain information from specific cells and put this into the subject
line
using office 2003

I've never worked with the Outlook object model, but
after scanning some of Ron de Bruin's code at:

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

wouldn't you use something like:

Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)

With OutMail
.Subject = Cells(1,1).Value 'Value in A1
End With

---
HTH
Jason
Atlanta, GA


-----Original Message-----
Using VB is it possible to use specific cell data and
import this into the
subject field of an email

Can easliy create code to email the excel document
succesfully, but need to
grab certain information from specific cells and put
this into the subject
line
using office 2003
.