Dear Sir,
Ref to attached sheet, I wanted to send an auto email to my customers and I have attached my sample excel file for your reference because original file size is big.
As per VBA code my A2 column will be the email address to whom I wanted to send an email as TO.
As per VBA code my A3 column will be the email address to whom I wanted to send an email as CC.
As per VBA code my A4 column will be the subject Line.
I wanted to generate report like once I double click into pivot a new sheet will generate for that customer but A2 and A3 should be the email address from customer contact details sheet.
Hi Sarfraz
Can you post a sample of what your expected result will like when you double-click?
Dear Sir,
Reference to attached sheet 1 is actual file gets generated and I wanted to get report like Sheet2.
Eg : Row no1 and Row no2 show as email id’s of customer.
Hi Sarfraz
See if this is what you want. Just double click on the Pivot Table to generate the report you requested.
