Had tried, it works beautiful!
You're welcome 🙂
So sorry just ask a bit more, in the Macro how to change the font style and font size in the Email body
For example :
Font style="Arial Italics"
Font Size =14
Hi David,
Replace the .Body lines with these
.htmlbody = "<p style=""font-family:arial;font-style:italic;font-size:14px;"">Dear Staffs,</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">Good day!</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">Attached please find this monthly Salary details and payment will be arranged at this month end, please keep for reference and income tax record.</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">BR.</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">HR Administrator</p>"
Regards
Phil
All in all, millions thanks to everyone interest in the post in particular, my tribute to Philp Treacy for his patience, precious time and guidance in this post.
You're welcome David.
.htmlbody = "<p style=""font-family:arial;font-style:italic;font-size:14px;"">Dear Staffs,</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">Good day!</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">Attached please find this monthly Salary details and payment will be arranged at this month end, please keep for reference and income tax record.</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">BR.</p>"
.htmlbody = .htmlbody & "<p style=""font-family:arial;font-style:italic;font-size:14px;"">HR Administrator</p>"
Sorry, what is the syntax to replace paragraph tag with line break for the last two lines
Dear Staffs,
Good day!
Attached please find this monthly Salary details and payment will be arranged at this month end, please keep for reference and income tax record.
BR.
HR Administrator
ie the spacing is too wide
Hi David,
Change these p tags to span and insert a br tag between the last 2 lines:
.htmlbody = .htmlbody & "<span style=""font-family:arial;font-style:italic;font-size:14px;"">BR.</span><br/>"
.htmlbody = .htmlbody & "<span style=""font-family:arial;font-style:italic;font-size:14px;"">HR Administrator</span>"
Phil
Deep Thanks again Philip!!My apology for all the fuss request!
🙂
