Email automation your help is very much appreciated

Hello

This helps generate Emaills with Excel attached file based on Pivot table

I am trying to let the user choose the generic Message before running the macro, through the use of input Box but for some reasons the input boxes are not showing in the messages

is it because the variable are defined on the Sub Macro ?

Can you help please ?

Thanks

Please Login or Register  to view this content.

Try defining the Input boxes as a Public Variable on top of the Sub

Please Login or Register  to view this content.

Sorry I m bit of a novel to Macros did you mean defining like this

Please Login or Register  to view this content.