PrashanthGM12345
Member
Hi Guru,
I am trying to write a VBA code for doing the following activity. Can anyone help me with this.
When i click on the shape "Click here to send email", the system should ask me a pop up telling "Please enter the Opportunity ID". Once i enter the Opportunity ID, the macro should automatically copy all the findings "From column A to Column B" along with the header for that particular entered Opportunity ID.
After copying all the data, it has to open Outlook and click on New Email, and paste all the copied data to that mail body.
How can i obtain the following activity done with the help of macros.
I have attached the excel file for the reference.
I am trying to write a VBA code for doing the following activity. Can anyone help me with this.
When i click on the shape "Click here to send email", the system should ask me a pop up telling "Please enter the Opportunity ID". Once i enter the Opportunity ID, the macro should automatically copy all the findings "From column A to Column B" along with the header for that particular entered Opportunity ID.
After copying all the data, it has to open Outlook and click on New Email, and paste all the copied data to that mail body.
How can i obtain the following activity done with the help of macros.
I have attached the excel file for the reference.
