Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smejicoiii

    Run Time Error '5631' automating merge from Word

    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...
  2. smejicoiii

    Run Time Error '5631' automating merge from Word

    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:=""...
  3. smejicoiii

    Run Time Error '5631' automating merge from Word

    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?
  4. smejicoiii

    Run Time Error '5631' automating merge from Word

    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...
  5. smejicoiii

    Run Time Error '5631' automating merge from Word

    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 ' '...

Part and Inventory Search

Back
Top