Hi!
I´m using excel 2011 for mac and wonder how I send an automatic e-mail with information from a sheet.
On sheet one I have a list of customers and their information.
I.e
NAME EMAIL
Anthony Hopkins anthouny_1817@hotmail.c
On sheet two I have a receipt that picks up information from sheet one about a certain customer (i.e anthony) if I put their client number in a cell.
Today I manually "print and email as pdf", copy paste their e-mail and send it.
What I want to do is to have an e-mail button on sheet 2. When I push it an email goes out to the customer whos information is on the receipt.
So basically the aboce process with "print and email as pdf" and so on should be controlled by me with only one click. Or two if neccessary.
I´m using excel 2011 for mac and wonder how I send an automatic e-mail with information from a sheet.
On sheet one I have a list of customers and their information.
I.e
NAME EMAIL
Anthony Hopkins anthouny_1817@hotmail.c
On sheet two I have a receipt that picks up information from sheet one about a certain customer (i.e anthony) if I put their client number in a cell.
Today I manually "print and email as pdf", copy paste their e-mail and send it.
What I want to do is to have an e-mail button on sheet 2. When I push it an email goes out to the customer whos information is on the receipt.
So basically the aboce process with "print and email as pdf" and so on should be controlled by me with only one click. Or two if neccessary.