Creating/Updating data in GP

Combined with Word's Mail Merge capibilities, macros are a great way to make mass updates in GP. This method for years with much success, but I have had many frustrations with it:

  1. I can never remember... - When I start the mail merge, I can never remember which type to choose; Letters, Envelopes... Directory
  2. Can't find the source correct data - Sometimes when I "Select Recipients", I have a hard time figuring out how to choose the correct data range from Excel.
  3. Wrong quotes - When editing macro in word, the smart quotes mess up the macro. You want to type a ' but Word gives you ‘ or ’. GP only works with the ' and bombs with the other two.
  4. Locked files - On many occasions, I'll want to edit the data in the Excel file, but I can't because Word is still open and has the Excel file locked.
  5. Header lines vs Repeating Lines - There are some lines in the macro that only need to be at the top of the file (#DEX... or an open window command for example). You have to remember to take them out of the macro so they are not repeated multiple times and then remember to add it back when you are done.
  6. File Save As / Renaming - After you run the mail merge, you have to save the results into a text file with a ".mac" file extension. Again, another simple step, but you have to remember the details.
  7. I can't remember... - This sounds familiar, but I'm not sure... There are many steps in multiple programs. Keeping them straight can be confusing.

If you haven't done much with mail merge and macros, this all may seem a bit odd and you may be saying to yourself, "What's the deal... what is he complaining about?" But if you have used mail merge and macros, hopefully (and unfortunatly) you can releate to what I am saying. Instead of complain about it, I thought "Hey, I'm a Software Engineer... I can fix this and make it simpler!" So, I have create an Excel spreadsheet (Replicator.xlsm) that you will hopefully find helpful and easy to use.

Replicator.xlsm Excel file. Version August 12, 2019

Replicator.pptx Power Point "help" file. Version 2018.10.16

GP Macro.xml Right click and save as. Custom colors for GP Macros in Notepad++ (It doesn't seem to be a valid xml file, but Notepad++ likes it)

Notepad ++ - free text editor

Replicator Version History

VersionDateFeatures 12, 2019Added "Data Table Name" so your data table can live in a different location (worksheet or workbook) 12, 2018Minor changes/fixes 29, 2018Major Update! Added MaxRecordNumber and changed UI layout
PriorOctober ??, 2017Initial release... Please upgrade! :)