Hi,
I only be able to give you some starting points to your issue.
I would create in the word document bookmarks first of all. Those bookmarks can then be updated via VBA so your document receives all the necessary informations of your Excel worksheet.
Once you got this sorted you write a code to send it to outlook.
Maybe this get you started and I am sure someone here can give you a code to automatically send it via outlook.
HTH
SW
|