Forum Discussion
Solved
How to do the Excel equivalent of a mail merge?
Hello, all! I'm trying to figure out the best way to accomplish something in Excel that's similar to a mail merge in Word. I have a spreadsheet that is essentially a form letter in Excel format... ...
Hi Mark,
That's with VBA. The idea is here https://www.tek-tips.com/faqs.cfm?fid=4223, first I found (believe you may find more samples). Instead of printing in your case you shall save the form as new file on each loop step.
Hi Mark,
That's with VBA. The idea is here https://www.tek-tips.com/faqs.cfm?fid=4223, first I found (believe you may find more samples). Instead of printing in your case you shall save the form as new file on each loop step.
The Excel Mail Merge works but I am trying to figure out how to "save the form as new file on each loop step" instead of MergePrint() or wsForm.PrintOut?