Forum Discussion
Emailing a different range of cells on the same tab to a number of different email recipients
I am building a spreadsheet which eventually gives me details of payments due from up to 100 customers. The final tab shows the same calculation with differing values for each of the customers so I was wondering if there is a way of sending the completed "invoices" by email. It would need to collect data from a range which would change every month. Ask questions of me because I have difficulty explaining very clearly as I'm a bit of a novice.
Cheers
Huw
This is definitely possible with VBA. You'll need to post a detailed example of how your data is set up and what you expect to see as a result. In this case it would really help if you provide a workbook with a before and after example... i.e. this is the data, these are the emails I expect to be sent to different customers, this is the range that should be incorporated in the email.
For general email VBA the best source I've found is Ron De Bruin:
https://www.rondebruin.nl/win/s1/outlook/mail.htm
If you can't find what you're looking for there or are unsure how to incorporate it to fit your needs please post back with more detail.
Hi Matt
Thanks for your response, I've been away to France for a couple of weeks so sorry for the late reply. I will attach the spreadsheet via PM which is what I've cobbled together to try and help my wifes business send fee invoices to her customers. The spread sheet works well to take the confusion out of invoicing manually but I wanted to move it on by being able to email the customers just the fee slip that applies to them. For the first child I would want to send the range of "D4 to L12", this would be for all slips to different email addy's. There are times when there could be brother and sister etc where two ranges would go to the same customer. It would be great if the email could include some text like "Please find below your fee slip for next month from A************b"
