Sorry for the cross posting macropod, my bad. Thank you for the information I just quickly tried using the SkipIf you mentioned but was not able to get it to work. I will try to look into it more tomorrow. It seems that this may be a known bug with the findrecord and vba as i found...
1st part is to ask for user input to locate the correct record...
ActiveDocument.MailMerge.OpenDataSource Name:= _
"H:\worddata\Setup\database.mdb SetupFile.odc", ConfirmConversions:= _
False, ReadOnly:=False, LinkToSource:=True, AddToRecentFiles:=False, _
PasswordDocument:=""...
Most of the code came from recording two different macros with the key strokes and then I was able to find the user input and then combining it all. Is there a better way to do this?
It is showing the error on the .Execute Pause:=False. Now if i run the routing and when prompted for input put nothing and hard code a record number for .FirstRecord = 1552 and .LastRecord = 1552 it will work as expected. I do not know if that helps you help me. Also I am using Word 2010...
Hi all first time here and I am trying to automate a merge document with input from the user. Debugging everything seems to be working fine until it gets time to finish and merge the document, any help would greatly be appreciated.
Code is below...
Sub testmerge()
'
' testmerge Macro
'
'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.