I tried the examples etc. But it all seems to go way over my head. I have tried copying the code from this video @3.38 http://www.youtube.com/watch?v=4Ck8KAwAQso: making sure I got the spacing etc correct. Then I messed around with the bit at the end to try it out.

I have attached my file - should you be kind enough / altruistic enough to have a look!

I keep getting MERGESEQ or it JUST shows the invoice ref / amount.

Nothing relating to the other fields? :S

Attached Files

MM_Trial.docx (15.5 KB, 28 views)

Your field code has a few errors. As for the video, I hadn't seen it before, but it is both misleading and inaccurate:
1. The field codes on the Microsoft website are just plain text and can't be used as is. The Microsoft website field codes are also quite different - I don't vouch for them; and
2. The field code the video purports to insert from the tutorial has different content to any that the tutorial has ever had. In other words, it wasn't imported as-is from the tutorial. What the video omits is that whoever produced it substantially edited the field codes beforehand. It also fails to mention that you need a dummy last record in the data source.

See attached revised version of your document. I should also point out that, whereas your thread title indicates a desire to "Send Via Email Merge", the process you're using is not for that - it is only for producing an output document or sending the output direct to the printer. The tutorial has an entirely different process for email merges.

Attached Files

MM_Trial.docx (14.6 KB, 44 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

You are a genius. How long you been doing advanced MW?

I tried emailing, said it was incompatible. However, mail merging to new doc - then sending via email merge should work no?

Or would it require a different if then else rule? I.e. if company name = 1 then send to 'x' email?

Thanks Macro