Thread: [Solved] mail merge error in vba
View Single Post
 
Old 03-08-2017, 11:22 AM
texas1014 texas1014 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2017
Posts: 2
texas1014 is on a distinguished road
Default mail merge error in vba

Good Morning,

I posted this in the Mail Merge thread as well.

I recorded a macro where I did a mail merge and it worked perfectly while in recording mode. When I executed it, it wouldn't work. I get the following error when it gets to the .Execute Pause:= False line of code:

Word cannot merge documents that can be distributed by mail or fax without a valid mail address. Choose the Setup button to select a mail address data field.

Where is the setup button? Why won't this work when running the macro, but when I recorded the steps, it worked fine?

Thanks,
Tex
Reply With Quote