Outlook Excel automation
Posted on 2016-09-25
I have an Excel table which I need to filter, need to copy resulting set into empty email and send it to appropriate recipient.
I tried to play with VBA in Excel, I can filter table, select resulting set, copy into clipboard. Then I can create mailitem object, however when I was to paste clipboard contect there via KEYSEND, I am not succesfull, I suspect excel to clean clipboard data when focus is changed from Excel to Outlook.
Do you have any suggestions?