Hello all..

I really hope somebody will be able to help me resolve my problem..

I am putting together an email mail merge which so far has gone fine, however - I'm finding it hard to explain so I'm going to use screenshots and annotate as I go along...


Dear «Name»
Thank you for taking the time to look at this email thread.. so as you can see I have done the simple part and mail merged the name in..
Now, I am going to add in fields, in the final document, there will be up to 70 cells but some will be blank.
«F3»
«F4»
«F5»
«F6»
«F7»
«F8»
«F9»
«F10»
«F11»
«F12»
Kindest regards,
Natasha

(Here you will see that I have upto 12 cells, now not all of those have data in them for each merge however as they are blank on the excel spreadsheet, I am happy to keep them in)

The question I am asking now though is: if the particular merge has only upto <<F6>>, how can I get the Kindest regards, Natasha to come up so there aren't a load of blank spaces where the blank fields are currently sitting)

I really hope this is making sense to someone and you're able to help me.

Thanks a lot,
Natasha91