Hello,
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.
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.