#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Can you post the code from the macro you recorded?
|
#3
|
||||
|
||||
I have closed that thread.
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] |
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 Number Error | Tamarrissa | Mail Merge | 2 | 11-09-2012 09:01 AM |
Error 5631 in Mail Merge | DoctorNadir | Mail Merge | 7 | 12-16-2011 04:38 PM |
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 |