Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2021, 04:11 AM
ylafont ylafont is offline Excel Macro with MSword Mail Merge using 2d Array Windows 10 Excel Macro with MSword Mail Merge using 2d Array Office 2016
Novice
Excel Macro with MSword Mail Merge using 2d Array
 
Join Date: Jul 2021
Posts: 2
ylafont is on a distinguished road
Default

gmayor

All the macros generating the mail merge and creating the forms are in Excel – so check there!

The criteria have changed a bit, now I have to read the initial array and select all matching records based on the selected record. I have already separated all matching records into a new 2D array, still need the last record of the new array for now (I think this may change - waiting on confirmation) allowing the user to select any record of the new array and regenerate the form. I started exporting the new array to a CSV file to be able to use the macros as they currently are.

I think your suggestion of content controls will eliminate the merge fields in the main document and the need to save the new array to a CSV, it should work nicely! Let me see if a can get into practice.



Thank you for the suggestion.
Reply With Quote
Reply

Tags
array msword excel



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro with MSword Mail Merge using 2d Array Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file sureshbvs Word VBA 1 03-12-2021 05:42 AM
Excel Macro with MSword Mail Merge using 2d Array Need macro to fill the values in msword based on the excel sheet info ganesang Word VBA 50 08-29-2018 12:53 AM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
Excel Macro with MSword Mail Merge using 2d Array Mail Merge Macro ch1325 Word VBA 2 06-08-2015 06:18 AM
msword email merge doc as pdf pablo Isl Mail Merge 3 06-09-2010 07:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 AM.


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