I've never used a macro to do mail merge. I find Albet Kallal's super easy mail merge utility perfect for the purpose.
The error message may suggest you have an old MDB file an a newer version of Access. Is that the case? If so, try converting to ACCDB
Also have a look at the similar threads at the bottom of this page.