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
|