I've created a control button and assigned it a macro as per below to copy text.
i need the functionality to extend this code.![]()
Sub COPY() ' ' COPY Macro ' ' Range("B4:K23").Select Selection.COPY End Sub
i want it to copy > open a new outlook message > paste the copied content in the body of the message.
insert "abc@xyz.com" in the TO field, "123@xyz.com" in the CC field & "This is a test message" in the subject field.
Is this possible?
P.S I think now i've used the codes as per the forum rules.
Bookmarks