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?
- Hi Sergei,
Can you please help me with below question?
I do have same question and very time whenever new data is updated in workbook 1(My data) I want to see same data in workbook 2(My form).
I have a quick question can you please explain me in detail, but i am unable to follow point C and point D.
I have attached my data and form (workbook 1 & 2) for reference.
Thank you in Advance for your help! - Wow, great find, Sergei! I will give that a go. Thank you so much for your help.
-Mark
