vgudulkar
New member
VBA to copy set of cells in email body & send it to an email address from same sheet
Hello all,
I have a spreadsheet that we use to measure the quality of work done by an engineer on technical cases assigned to them.
What I wish to do is once the audit is complete the reviewer should be able to send cells A2:G18 in the body of an email (not as attachment) to the engineer along with a CC to his manager?
I have attached this spread sheet for your reference. I have been looking at some other posts in this forum e.g. Vba to copy cells and paste into outlook. However, this is not exactly what I am looking for.
I intend to have a button which when pressed an email will go via Microsoft Outlook.
We use Office 2003 when in office & Office 2007 at home. Hence, expect this to work with both Excel 2003 & 2007.
The email address from K2 should become the 'To' & K3 should become the 'CC' email address.
Subject line of the email should be 'Quality Audit'.
Email body to contain following information -
Hi C2 (this will be the name of the engineer),
Your case quality audit has been completed. Please find below the feedback.
(A2:G18)
Regards,
C3 (this will be the name of the reviewer)
Hello all,
I have a spreadsheet that we use to measure the quality of work done by an engineer on technical cases assigned to them.
What I wish to do is once the audit is complete the reviewer should be able to send cells A2:G18 in the body of an email (not as attachment) to the engineer along with a CC to his manager?
I have attached this spread sheet for your reference. I have been looking at some other posts in this forum e.g. Vba to copy cells and paste into outlook. However, this is not exactly what I am looking for.
I intend to have a button which when pressed an email will go via Microsoft Outlook.
We use Office 2003 when in office & Office 2007 at home. Hence, expect this to work with both Excel 2003 & 2007.
The email address from K2 should become the 'To' & K3 should become the 'CC' email address.
Subject line of the email should be 'Quality Audit'.
Email body to contain following information -
Hi C2 (this will be the name of the engineer),
Your case quality audit has been completed. Please find below the feedback.
(A2:G18)
Regards,
C3 (this will be the name of the reviewer)