Macro help...

[#1]

Hi all,

I have written a macro for sending mails on reload of an app, in this i have to send tables in one sheet whereas this sheet should be hidden in main app. So how can i get to run a macro and get the mails from that sheet which i will hide in that app.

Kindly suggest any other better way, if any.

Regards

[engishfaque]

Dear Rajeshree,

Please share a sample file.

Kind regards,

Ishfaque Ahmed

[m_woolf]

The only way to do it is with a .bat file. Publisher or the Server reloads do not executive any macros.

[#4]

when i hide the sheet and run through .bat file  its not working(no mail received). Is there any way so that I can hide that sheet and can receive mails.

[m_woolf]

Does it work when you run it in the client?

If so, it should work in the batch file.

If it doesn't work because the sheet is hidden, you can always unhide the sheet in the macro and then hide again at the end.

[#6]

can u please share the command to undide the sheet in the macro and then hide again at the end?

[m_woolf]

Conditionally show the sheet with a variable.

The macro will change the value of the variable.