Thank you for the videos - I wonder if it is possible to mailmerge an excel table (e.g. an 3x5 table with headers and rows, rather than just individual cells) into the Word using the same technique you shown?
Loved the videos, definitely the best/most clear startup videos for someone just starting to learn word mail merge/VBA. One question, how do you prevent the mail merge from creating separate documents for each data source record? For example, if you wanted to just print out each record's "name" field on one page of the word document.
So not sure if you saw the end of the video, but for this video, it won't create separate documents, each page in the document will be its own "document". I would say if want a single massive document then use the code in this video.
@@SigmaCoding Thanks for the quick reply. I think I found the solution to my problem. Rather than adding actual merge fields to my word document I'm grabbing the actual field values and adding those. That way I can run the VBA module without actually "executing" the mail merge and creating a lot of pages since my data source spreadsheet is rather large it tends to overload the program and go into the not-responding state.
Thank you for the videos - I wonder if it is possible to mailmerge an excel table (e.g. an 3x5 table with headers and rows, rather than just individual cells) into the Word using the same technique you shown?
Loved the videos, definitely the best/most clear startup videos for someone just starting to learn word mail merge/VBA. One question, how do you prevent the mail merge from creating separate documents for each data source record? For example, if you wanted to just print out each record's "name" field on one page of the word document.
So not sure if you saw the end of the video, but for this video, it won't create separate documents, each page in the document will be its own "document". I would say if want a single massive document then use the code in this video.
@@SigmaCoding Thanks for the quick reply. I think I found the solution to my problem. Rather than adding actual merge fields to my word document I'm grabbing the actual field values and adding those. That way I can run the VBA module without actually "executing" the mail merge and creating a lot of pages since my data source spreadsheet is rather large it tends to overload the program and go into the not-responding state.
Yeah that sounds like a smart move, especially if you're going to have a very large data source.
Thank you. It's great and helpful. Please could you share how to do mail merge from Excel VBA (data source: from closed Workbook)
Hola, quisiera poder separar en un documento cada uno de los registros de la base de dato. Cómo lo haces?