Hi I have a excel spreadsheet that I use for creating invoices. I originally printed the "invoice" sheet as a PDF file, then attached the PDF to email and sent it to the customer. I'm now trying to simplify the process so I can email the invoice directly from excel.
I have a Hyperlink function =HYPERLINK("mailto:"&B21&"?Subject="&K8&"&body="&K9,"Click Here"
But this only sends the contents of cell K9. Iv tried altering the body=parameters, but anything but a single cell gives a #Value error.
Question: I need to send a section of the worksheet B1:F35 (the complete invoice) I cant seem to alter the hyperlink to send more than just one cell at a time.
any help greatly appreciated
I have a Hyperlink function =HYPERLINK("mailto:"&B21&"?Subject="&K8&"&body="&K9,"Click Here"
But this only sends the contents of cell K9. Iv tried altering the body=parameters, but anything but a single cell gives a #Value error.
Question: I need to send a section of the worksheet B1:F35 (the complete invoice) I cant seem to alter the hyperlink to send more than just one cell at a time.
any help greatly appreciated