Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-08-2017, 09:37 AM
texas1014 texas1014 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2017
Posts: 2
texas1014 is on a distinguished road
Default vba error when trying to do a mail merge

Good Morning,
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
  #2  
Old 03-08-2017, 03:23 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Please don't start multiple threads on the same topic. Doing so only causes confusion.

Thread closed.

You may continue the discussion in your other thread: http://www.msofficeforums.com/word-v...error-vba.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Closed Thread

Tags
mail merge help, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Number Error Tamarrissa Mail Merge 2 11-09-2012 09:01 AM
Mail Merge error message rec Mail Merge 1 04-29-2011 10:30 PM
Mail merge error? SRE Outlook 0 01-11-2010 05:54 PM
Error Message in Mail Merge A Bhavani Mail Merge 0 11-26-2008 12:08 PM
Mail Merge Calculation Error Lsbutler2000 Mail Merge 1 06-22-2007 06:33 AM


All times are GMT -7. The time now is 11:35 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft