See attached.
I've made a few minor changes to the last part of the macro code so your indenting of the data will be respected, but that's about all on the macro side of things. I've also applied some tab-stops to your 'Email Merge Main Document' to manage the alignments and reformatted the Invoice Amount field to put the £ symbol into the field and apply a thousands separator. That said, you have no control over whether your recipients will view the emails with quite the same layout as you send them. I also had to clear out some empty rows from your workbook.
Also, the code presently sends the output to a new document (for testing), but I'm sure by now you know how to change that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|