.subject

  1. T

    Adding Named Range to Body of Email

    What i need to just a simple way to get a group of cells to copy into my body of the email. I have tried this: .Subject = "TURN UP " & Range("B15") .HTMLBody = Range("A15..B21") And this: .Subject = "TURN UP " & Range("B15") .HTMLBody = Range("TURNUP") But both...
  2. H

    Macro Email Subject

    I have a macro for emailing which works perfectly, except I cannot get the subject to pull through from a named range called SubjectText B2 is named as SubjectText Book1AB1Email2SubjectSales for Aug 20173BodyAttached please Sales data for Sep 2017 RegardsSheet1 Zsubject = [subjectText]...
  3. H

    email Macro Subject line

    I have the following code to enable a user to attach a workbook and to email this I would like the section of code containing .Subject = to contain the "Summary Sales figures for + the name of the workbook attached or eg if name of workbook attached is BR.xls then .Subject = must appears as...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top