Mailmerge e-mail

[ajcarr]

I am trying to use Mailmerge to send to a list of e-mail addresses held in an Excel workbook. I can't find how to link to link to the address table in the Word VBA Macro. I've tried using macro recorder but it doesn't record this part of the process. I presume it has to link to the mailaddressfieldname but what is the exact format?

 

[ajcarr]

Have found the cause of the problem. The column heading in Excel that I was using for the addresses was "e-mail". Mailmerge seems not to like the "-" and when I changed the heading to "email", the mailmerge macro worked fine.