I can get outlook to create an email and set the subject and body text but is it possible to import information from an open excel spreadsheet for example:
Subject: "My party guest list as at " & Date (where Date is lifted from a specific cell on an open spreadsheet).
Can Outlook be made to 'see' the Excel object?
I thought I could have used somethinglike excel.activeworksheets.blahblahblah but no dice.
My knowledge of VBA is extremely basic.
Subject: "My party guest list as at " & Date (where Date is lifted from a specific cell on an open spreadsheet).
Can Outlook be made to 'see' the Excel object?
I thought I could have used somethinglike excel.activeworksheets.blahblahblah but no dice.
My knowledge of VBA is extremely basic.
