Emailing from Excel

C

Chris Brown

I have set up a macro that emails a sheet and retains the name of the
workbook in the subject line when Outlook is opened. I would like for it to
retain the name of the workbook, but I want to add the data from a particular
cell to the subject line as well.

Subject line example: NISR05 - Plastic Cup

Where "NISR05" is the name of the workbook and "Plastic Cup" is the data
located in cell B4.

Any help would be greatly appreciated!
 
S

Steve Schapel

Chris,

The focus of this newsgroup is macros within Access, the database tool,
which are very different from Excel macros. You will have a better
chance of good help in an Excel newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Emailing From Excel 11
Have 4 email addresses Want to auto forward all in one of them 0
Crating User Form to Add Names 1
Macro: VBA code to move/forward email based on subjects and attachments 0
Auto populate value from one task to another in MS PROJECT 0
Integrating information from Word to Excel (not mail merge) 1
Allow Macro to Work by Selecting Cell Description 4
Excel 2010 Data Labels options not saving 0

Top