Specific data from a table added to email Subject through using VBA

[blimey88]

Good morning all,

As ever I am stuck and need some help, I have my email function working and I am successfully adding an attachment also, however i have a % of inspections completed located in a table that i need to be part of the email, preferably in the subject?

 

[daverunt]

Hi,

it should be straightforward.

.Subject = Range("B2").Value & "% of Inspections completed"    'change range as required

 

[blimey88]

Hi,

it should be straightforward.

.Subject = Range("B2").Value & "% of Inspections completed"    'change range as required

Great I'll give this a try! Many thanks