Had a lot of help from TSTom and Snozgur but had recent crash and lost your E-Mail address's.
Need a macro that will:-
a) Select a range in worksheet (CopySheet) Range C3:H12 (Using Excel 2000)
b) Open Outlook (2000)
c) Past selection into text area whilsh maintaining formating.
Addressee will then be selected in the normal way via the Outlook address book.
Snozgur almost got the answer but it seemed very much O/S and Office version specific.
Need a macro that will:-
a) Select a range in worksheet (CopySheet) Range C3:H12 (Using Excel 2000)
b) Open Outlook (2000)
c) Past selection into text area whilsh maintaining formating.
Addressee will then be selected in the normal way via the Outlook address book.
Snozgur almost got the answer but it seemed very much O/S and Office version specific.