RTE:4605 - This Method or Property is not available because the clipboard is empty or not valid

[ExcelNewbie2020]

Sirs,

I have a vba script that is working. It copy and paste a certain range from excel then paste it to outlook then sending it to a recipient. It works properly if i use a button to run it.

I thought of automating the sending of email every 5PM instead of hitting a button. So i used the line below.

Private Sub Workbook_Open()

Application.OnTime TimeValue("17:00:00"), "SendmanpowerInEmail"

End Sub

However, its not sending it gives this
RTE:4605 - This Method or Property is not available because the clipboard is empty or not valid.

Is there in any way to fix this?. thank you..

 

[Skyybot]

Is there something somewhere setting your CutCopyMode to False?

 

[ExcelNewbie2020]

Is there something somewhere setting your CutCopyMode to False?

none..i searched from the whole module.. i replaced the time when my computer is active and it works smoothly.. Maybe the issue arise when my computer is idle?
at 5PM my computer is lock but my excel file and outlook are open..

 

[Skyybot]

Possibly. If the machine is in Sleep mode. Have you investigated Windows Task Scheduler?

 

[ExcelNewbie2020]

Possibly. If the machine is in Sleep mode. Have you investigated Windows Task Scheduler?

sleep is already set to "Never".. maybe the issue here is not the script.. I will try task scheduler to activate the excel file before macro starts.. thankyou