Hey Gmayor,

My purpose gets met when i add the subject line as
 .Subject = olMail.Subject & " - " & "123" 'is the message subject. Edit it as required
however what i wish to achieve is a loop to search a2 and then paste b2 in the subecjt instead of the 123 i've mentioned now
and then search for a3 and then paste b3 in the subject line before printing. i've removed the .save code as i do not wish to make any changes to the original message.

i'm unable to run this in loop, your code only searches for the last row in the column A as seen in the code which is not what i wish to achieve.

thank you.