Forum

Notifications
Clear all

Pivot Table

5 Posts
4 Users
0 Reactions
143 Views
(@sarfrazkhan)
Posts: 30
Trusted Member
Topic starter
 

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.

 
Posted : 20/09/2016 5:05 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Sarfraz

There is no attachment.

 
Posted : 20/09/2016 7:32 pm
(@sarfrazkhan)
Posts: 30
Trusted Member
Topic starter
 

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.

 
Posted : 21/09/2016 6:38 am
(@fravis)
Posts: 337
Reputable Member
 

SunnyKow said
Hi Sarfraz

There is no attachment.  

second time, same message without attachment.......?

 
Posted : 21/09/2016 2:27 pm
(@mynda)
Posts: 4761
Member Admin
 

Note that there are 2 buttons for finalizing an upload:

-Add Files button, this will allow you to browse to select the file, and:

-Start Upload button, this will actually perform the upload, if you use only the Add Files button, no file will be added.

 
Posted : 22/09/2016 1:46 am
Share: