I would like to have a button that will generate an email with the following information:
To field = Column (I & J)
Subject = Please respond in regards to CID: (Column B) / Order #: (Column C) / Container #: (Column D)
Body = Please advise once container #: (Column D) is picked up on (Column E) so the triage team can close out the order.
It is setup as a table so I would need it to loop through each one on the sheet that does not have "X" in column K. I have attached the workbook so you can see what it all requires! Any help would be greatly apricated! Thank you so much in advance!
Bookmarks