Hi ALan,
Plz find the workbook for your reference to insert salutation based on time (mail sent)
Also I would like to point out two more issue am facing with this macro.
I am using this macro to send the sheets(not workbook) as attachment to the specified mail id the VBA code.
if the mentioned sheet not available in the workbook then macro gets stopped. Kindly help amend the VBA code as if the specified sheet is not available then it should move to the next command.
Also I want to change the font, size and colour in the body of the email.(I preferred to send courier new with font size 11)
Kindly do the needful.
Prabhu




Reply With Quote
Bookmarks