MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Sorry about this folks - I've got to re-produce a load of invoices from other data and I have to do it quickly, so hopefully the experts here will forgive me for not doing my own Googling.
I'm making a list of the amounts in Excel, and for each amount I need to make a Word invoice. So the word doc needs to have 'fields' in it, and I need to load the word file, change the data and save a copy for each week. Any tips or pointers for where to start or look for info?
Will a mail merge do it?
Mail Merge, be careful it's normally dodgy in setup but can work wonders for this kinda thing.
Failing that create "invoices" out of a Tab and write some code to collect the Invoice address/amount/InvNum etc. so that it goes down each row, collects data, pastes it into Invoice, prints it, clears it and does the sequence all over again...
but really...
Mail Merge.
Blimey.. I haven't heard anyone mention 'mail merge' in many years!
Will check it out, thanks 🙂