Adding Subject to automatic email from excel

[Luke1690]

HI,

thanks for your help guys ive asked a few questions already and got answers back straight away. im a beginner and just getting by using snippets of code.

with this question im sending the workbook as an attachment using outlook.
i can send the email no problem. i want to add a Subject to the email i want to pull the subject from a specific cell within the work book.
please can someone tell me the code for this?

i tried the below with no luck, im a beginner so take it easy.

emailitem.Subject = Range.("d7")

 

[Luke1690]

HI,

thanks for your help guys ive asked a few questions already and got answers back straight away. im a beginner and just getting by using snippets of code.

with this question im sending the workbook as an attachment using outlook.
i can send the email no problem. i want to add a Subject to the email i want to pull the subject from a specific cell within the work book.
please can someone tell me the code for this?

i tried the below with no luck, im a beginner so take it easy.

emailitem.Subject = Range.("d7")

sorted thankyou

 

[Peter_SSs]

Good to hear you got a solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.