Excel macro that opens new MS Word file and pastes data as a pictu
 

Greetings,

I am new to the macro world but am attempting to automate a process for my
sales department.

1. What I would like to do is write a excel macro that selects a given range
(A1 to O72), copies the info and pastes it into a new word file as a picture
(enhanced metafile).

2. I would also like to write another excel macro that takes that same
information (A1 to O72), converts it into a picture (enhanced metafile) and
opens a new outlook email message with the picture already attached to the
email.

I am using word, excel and outlook 2003.

Any solutions or suggestions would be greatly appreciated.

Thanks
Rob