VBA to send range/sheet in the body while workbook is inactive

[ChipsSlave]

Hello all,

Currently I'm running with a script that sends ranges to the list of recipients. Unfortunately I have discovered that this can be done only while workbook is active as script is selecting the range. If macro runs at scheduled time and workbook is inactive, outlook and excel crashed and requires to be closed through task manager. I would like my spreadsheet to send emails while its inactive, that means while I'm using different spreadsheet or have browser up. Ideally I would like my contents to appear in the body of the email. Please find the macro that I'm using now below:

Any suggestions guys?

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

One way would be to have the send_updates procedure reactivate the workbook that contains the procedure. So as the first line add

Please Login or Register  to view this content.

and in the procedure name add st as the variable. i.e.

Please Login or Register  to view this content.

Then have the Ontime macro pass the workbook name. i.e.

Please Login or Register  to view this content.

Note that the single quotes around the whole calling procedure/wb name and double quotes around the workbook name are vital.

[ChipsSlave]

Seems to be I have resolved the issue.

Please Login or Register  to view this content.

workbook name
module name where is macro stored that i want to run
macro that im calling

Please Login or Register  to view this content.