L
Legacy 316613
Guest
Hi Forum,
Need some help here with VBA automation.
I have a macro which captures data from an excel range and converts it into a PDF to then be sent via email through Outlook.
However, I would like that at time of capture of the excel range, if I could use VBA to customize the PDF in which, the PDF includes:
1) our company logo in the header (top right hand of page),
2) a Title "Back Order Report" in the Centre and
3) a Disclaimer in the footer which will be standard text as per our terms and conditions which I am unable to detail here in open forum. However for ready reference it will be free form text which is not dynamic. For example "Quantities once delivered cannot be returned. If you however want to cancel your order, please .......... etc."
Please help
Need some help here with VBA automation.
I have a macro which captures data from an excel range and converts it into a PDF to then be sent via email through Outlook.
However, I would like that at time of capture of the excel range, if I could use VBA to customize the PDF in which, the PDF includes:
1) our company logo in the header (top right hand of page),
2) a Title "Back Order Report" in the Centre and
3) a Disclaimer in the footer which will be standard text as per our terms and conditions which I am unable to detail here in open forum. However for ready reference it will be free form text which is not dynamic. For example "Quantities once delivered cannot be returned. If you however want to cancel your order, please .......... etc."
Please help
