VBA Novice needs some help.

First off, is it possible to link more than one Office app together in one VBA script?

I currently have system generated e-mails come into my inbox from the same sender several times daily. I want to be able to either save the mail as text or copy the mail text (including message evelope) and paste/import into an excel file.

From there I have a macro currently set up to extract the info I need and organize into rows and columns.

Once spliced in Excel, I have a Word form that links to the Excel file to autopopulate a form.

Once the form is populated I then want to attach it to an e-mail and send to the same address everytime.

Not sure if this is just a pipe dream or if it can actually be done.

I tried make it as simple as possible, but any and all opinions are welcomed.

Thanks in advance.

Ross