I'm trying to send zip files via the SMTPSendMail approach. Larger files, or slower PC's, result in an error if the time to assemble the attachement requires a bit more than 10 minutes. I was hoping that settting the SMTP_TIMEOUT to a larger number would help; but, no joy. It seems like the SMTPSend...

Does the username accept the domain as qualifer; for example, DOMAIN\username?

If not, is there another way to specify the domain?

Is there anything special required within the Subroutine to expose the variable? In the code below, the PW variable is correctly populated; but, I'm not seeing it in the script where I was calling the subroutine. I saw a mention of variable format under the SRT documentation; but, haven't found an e...

I want to assign a variable within a subroutine and make it available to the main scrip.

I've not found variable scope rules so far.

Am I missing something simple?

Thanks,

Carl

That worked. Thanks.

I created and ran a separate script to get the screen image file.

If I need to make this portable across users with different screen resolutions, I guess I'd need to capture at each resolution or is there a better way?

Take care,

Carl

I use a program named ShowCase (SPSS) to query data from our AS/400 and return it to an Excel workbook. After the data is returned, it triggers a macro refreshing all the PivotTables in the workbook. The script now correctly starts the workbook, chooses to Refresh the Data, logs into ShowCase server...