Outlook VBA - How to set excel sheet as mail body with WordMail as editor

Mar 28, 2009
Reaction score
I am having a hard time creating an e-mail item with a worksheet as body from outlook. Until now, i have succeeded to move mail items from one folder to another, to extract needed information from that mails, to create some excel files based on some criteria, to create new mails and attach the excel files but I don't know how to set the body of the mail to be the worksheet of the excel.
I am using Outlook 2003 with SP3 and i use Word as editor.

PS: I am very new to vba world (my first contact was about 2 weeks ago)
Thanks in advance to anyone who replies.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question