Outlook Excel automation

Hi Experts

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?

Thanks

Vladimir
vladobbAsked:
Who is Participating?
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
The best source for excel-outlook automation is Ron de Bruin. I'm sure that you will find something there. Post back if you need further help
0
 
vladobbAuthor Commented:
ABSOLUTELLY FANTASIC, thanks, by this link you simply answered all possible Excel/Outlook automation questions, thanks.

V
0
 
vladobbAuthor Commented:
What to say, superb :-)
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help, but Ron is the hero!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.