Dont know if what i'm attempting to do is possible. Im sure it must be. I am very stuck though! Tried for hours.

Please help?

Ultimatey, I am trying to mailmerge a spreadsheet relating to invoices. there are multiple rows for each company, however each row is a unique Invoice Number.

Instead of email mail merging normally, I want just one mail merge made for each company, where it lists the invoices there, rather than a whole new document per row. Otherwise I'd send one company 50 emails!

I have attached an example spreadhseet - and I have attached a screenshot of the word document Im working on.

Dont ask me where I got that code at the top of the word document - ive copied and pasted from somewhere - it might as well be written in italian. Im trying to match the mergefields with what I think it's trying to denote. Yet, I cant make an If then else mergefield?

Anyway - could you help?

Is it possible to do this sort of mail merge, then use the email column to designate where to send the finished merged product?

THANKS!