I have a macro for emailing which works perfectly, except I cannot get the subject to pull through from a named range called SubjectText
B2 is named as SubjectText
Book1AB1Email2SubjectSales for Aug 20173BodyAttached please Sales data for Sep 2017
RegardsSheet1
Zsubject = [subjectText]...