Macro to take date of Pivot results to Outlook msg template fields
Is it possible for a macro to run through the results of a refreshed pivot table to take the values into an Outlook mail.
From the sample attached:
It would need to take the order ref and use the data sheet to replace the fields which are between the # signs. New rows would be needed if a Unit has more than one order in the 1 day alert stage.