Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2017, 11:22 AM
texas1014 texas1014 is offline mail merge error in vba Windows 7 64bit mail merge error in vba Office 2013
Novice
mail merge error in vba
 
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
  #2  
Old 03-08-2017, 02:34 PM
dwirony dwirony is offline mail merge error in vba Windows 7 64bit mail merge error in vba Office 2003
Advanced Beginner
 
Join Date: Oct 2016
Posts: 49
dwirony will become famous soon enough
Default

Can you post the code from the macro you recorded?
Reply With Quote
  #3  
Old 03-08-2017, 03:25 PM
macropod's Avatar
macropod macropod is offline mail merge error in vba Windows 7 64bit mail merge error in vba Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by texas1014 View Post
I posted this in the Mail Merge thread as well.
I have closed that thread.
Quote:
Originally Posted by texas1014 View Post
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. ... Why won't this work when running the macro, but when I recorded the steps, it worked fine?
Without seeing your code and knowing precisely what you were trying to record, I can only suggest the reason is that the macro recorder hasn't actually recorded all the steps; that's a known limitation of the macro recorder.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge help, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
vba error when trying to do a mail merge texas1014 Mail Merge 1 03-08-2017 03:23 PM
mail merge error in vba Mail Merge Number Error Tamarrissa Mail Merge 2 11-09-2012 09:01 AM
mail merge error in vba Error 5631 in Mail Merge DoctorNadir Mail Merge 7 12-16-2011 04:38 PM
mail merge error in vba 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft