VBA Code copy text from Excel into Outlook subject line

[peter8848]

Hi All,

I learned some codes from online insert / copy data from excel into outlook body and send it. However I am struggling to do the same thing for the outlook email line.

Any help will be much appreciated. Thanks

Peter

 

[Domenic]

Try something like...

olMailItem.Subject = Worksheets("Sheet1").Range("B2").Value

...where olMailItem represents a mail item, and B2 contains the text to be entered in the subject line.

Hope this helps!