Hello,
I'm looking for a way to automatize a couple of things for my work, as we're forced into having to make a lot of unnecessary handlings, through system’s not being set up right to provide what we need.
We're working with Dynamics AX and when we need to make an invoice for the customs for shipments outside of the EU, we're having to extract a Pro Forma Invoice to Word, then manually remove "Proforma", so only Invoice is shown.
Then if there are multiple pages, we have to print the invoice, manually remove the page numbering with Tipp-Ex and write down the correct numbers, as the page numbering is in the header so it reflects the same on every page.
So my 1st question is, is there a way to remove the header, without removing the content of the header itself, so the page will look exactly the same.
I've attached 3 screenshots. The 1st is how the invoice looks when it's extracted from the system with the area from the header and footer shown, the 2nd is how it looks after we've amended it and the 3rd is the issue we have with the page numbering.
Then we often need to fill-in a template in Word and e-mail it along with the invoice to the transporters, so they can arrange to pick it up.
It would be ideal to have like 2 buttons, 1 to remove the headers and footers from the file and 1 to merge the 2 files together into 1.
I’ve already created the macro to save as PDF and send the e-mail to transporter, only I don't know how to remove the header without the contents of the header being cleared. Have tried googling it, but couldn't find it anywhere and made several attempts to make a copy/paste script and tried recording my handlings, but that didn't work neither.
Is there anyone that could possibly help me out?
Reply With Quote
