Hi,
I went through http://www.rondebruin.nl/sendmail.htm however it did not help since I am not much familiar with writing VBA code.
Can anyone help me with VBA to send email based on values in Excel pivot? I have embedded a sample excel file below:-
I need separate email where column A value changes which should have body of email from column B to G. Emails in To and CC can be picked up from column H and I respectively. Rest of the body like "Hi, please find below details" can be static for all emails.
<tbody>
</tbody>
<tbody>
</tbody>
I went through http://www.rondebruin.nl/sendmail.htm however it did not help since I am not much familiar with writing VBA code.
Can anyone help me with VBA to send email based on values in Excel pivot? I have embedded a sample excel file below:-
I need separate email where column A value changes which should have body of email from column B to G. Emails in To and CC can be picked up from column H and I respectively. Rest of the body like "Hi, please find below details" can be static for all emails.
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Join | Party | AffiliateParty | Code | Invoice Date | Invoice No. | Total | To | CC |
2 | IN1000AU1000 | IN1000 | AU1000 | Hello | 09/01/2019 | 856166785 | -2,10,696 | 123@gmail.com,456@gmail.com | 789@gmail.com |
3 | IN1000AU1000 | IN1000 | AU1000 | Hello Total | -2,10,696 | 123@gmail.com,456@gmail.com | 789@gmail.com | ||
4 | IN1000AU2000 | IN1000 | AU2000 | Hello | 09/01/2019 | 856166786 | -7,37,437 | 123@gmail.com,456@gmail.com | 789@gmail.com |
5 | IN1000AU2000 | IN1000 | AU2000 | Hello Total | -7,37,437 | 123@gmail.com,456@gmail.com | 789@gmail.com | ||
6 | IN1000CH1000 | IN1000 | CH1000 | Hello | 18/01/2019 | 856166913 | -1,07,928 | 123@gmail.com,456@gmail.com | 789@gmail.com |
7 | IN1000CH1000 | IN1000 | CH1000 | Hello Total | -1,07,928 | 123@gmail.com,456@gmail.com | 789@gmail.com | ||
8 | IN1000GB1000 | IN1000 | GB1000 | Hello | 22/01/2019 | 856166937 | -4,32,250 | 123@gmail.com,456@gmail.com | 789@gmail.com |
9 | IN1000GB1000 | IN1000 | GB1000 | Hello | 19/02/2019 | 856167320 | -1,64,273 | 123@gmail.com,456@gmail.com | 789@gmail.com |
10 | IN1000GB1000 | IN1000 | GB1000 | Hello Total | -5,96,522 | 123@gmail.com,456@gmail.com | 789@gmail.com |
<tbody>
</tbody>
Sheet1
<tbody>
</tbody>
Last edited: