VBA to Send Email with Outlook

Originally Posted by PCI

Is the list of Red or Orange Dies long ???
In other word, do we attach a file ( PDF one) with the list of dies or do we record the Dies reference in the Email ???

Just the email body includes reference to the part number in column A. and Each line is the part number and what kind of warning it is. (refer to my example for email body sample)


So in the end the email will look something like:

Subject: Dies that require checking
Body: Die "XXXXX" - Please check die for completion ETA.
Die "YYYYY" - Please check die for completion ETA.
Die "ZZZZZ" - Due Today/Past Due, please follow asap.