Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
andrew
 
Posts: n/a
Default 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
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy/print specific data Anthony Excel Worksheet Functions 3 January 26th 05 11:47 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
How do I include cell data in subject line of email address/hyperl gvinnola Excel Worksheet Functions 1 November 18th 04 03:36 AM


All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"