Need VBA to press enter for task scheduler to run.

**kbacker21** · 04-18-2019, 11:01 AM

This is my first post here and have zero experience writing VBA. My forte is injection molding, so I would appreciate any help.

Our plant manager put me in charge of a daily report that needs sent out to a group of individuals within the organization. I was able to write the macros to refresh the data from our ERP system, save the excel file to a pdf, attach it to an email with the people needed and send it. My issue is that we have the send confirmation dialog box that pops up on every email we send and I need to be able to hit enter in the macro so that the task scheduler will run without any interaction.

sendconfirmation.png

I've been mostly getting by with youtube or google, but can't seem to find anything that is helping with this one. I tried sendkeys with no success.

sendremindermail.JPG

Thank you in advance for the help!

Kevin

**dominicb** · 04-18-2019, 11:48 AM

Good afternoon kbacker21

You could try the solution offered here.

It's not really designed to be used with this particular dialog box, but it basically waits for 2 seconds (to allow th box to fully load) and then sends and Enter keypress. It may or may not work. You might also try exploring the CDO option (on the same page) - it might just fire an e-mail off without showing the warning you experience.

HTH

DominicB

Need VBA to press enter for task scheduler to run.

LinkBack

Thread Tools

Rate This Thread

Display

Need VBA to press enter for task scheduler to run.

Re: Need VBA to press enter for task scheduler to run.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Task List Scheduler

Scheduling A Macro To Run Via Task Scheduler

Help with Task scheduler to run a Macro

Running Excel from task scheduler. Scheduler doesn't end

Excel 2007 : disable task scheduler

Connecting VBA macro to OS Task Scheduler

[SOLVED] task scheduler

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions