I work in an accounts department for a company, each week we pay some of our clients and staff expenses via BACS.
We then send out remittances advices in the post after printing them off. Our current method of printing remittance advices is an excel spreadsheet mail merged into a word document.
My manager has asked me whether it would be possible to email remittance advices out to our staff instead of posting them, but i haven’t a clue how to go about this, can anybody help?
September 9th, 2010 on 1:31 pm
your half way there you already merge the excel info into word – in the excel data you need to add the email address and then when you go to run the merge you have the option to merge to email – setup a small test one to begin with using your own email address or colleagues before going live with this.