email from an excell spreadsheet

I want to email 40 customers with an indiviual price. The product price changes once per day and each customer has unique freight that must be added to product price. I want to enter the new price then have the spreadsheet calculate the delivered price including freight and email each customer with their own delivered price.