Help request to insert a title in between salutation and the name of person in messagebody

[mso3]

Hi friends,
The file name of attachment is the same as the name of the person in column ‘N’.
If I add a title to it then it gives error while converting word file to pdf. So there is no title in column ‘N’. The program matches the name of person column ‘N’ to the attachment stored in the ‘OUTPUT’ folder and attaches it to the mail.

My requirement is that I want a title in between the salutation and the name of person in the mail body which is in column ‘C’. We can insert it only after attaching the attachment because if we insert it before attaching the attachment then it will not match the name of attachment and name of person and as a result the attachment will not be attached. So I want to add it after attaching the attachment. There are two macros in the workbook namely ‘Birthday’ and ‘Holiday’.

Any help will be highly appreciated.

Thanking you in anticipation.

[antoka05]

See attached file, I hope that it's what you need.

Regards,
Antonio

[mso3]

Hi antoka05,
Excellent! It’s working fine as per requirement for ‘Holiday’ macro. Please do suggest me the same amendment in the ‘Birthday’ macro.

Thanking you.

[mso3]

Hi Antonio ,

Greetings from me!

Thank you for your kind cooperation to solve my problem.

I appreciate you for the same.

Thank you and have a nice day.