Hi,
I am a total VBA newbie but work a lot with excel in my work. Every month we update a pricelist table for several locations and need to send the updated price to each location email. How can we create a "Send email" button which will open outlook, pick the updated price for the respective location, put it in the mail body and also choose the location email address. Right now, we have an excel table which is updated every month and do all the rest of the work manually!!
Thank so much for your support
Kind regards
Yannis