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.
One email would be needed for each Unit. Could a macro actually acheive this?