How To Create Word Documents From Excel WITHOUT Mail Merge [Free Download]
Why Stack Overflow recommends it
Stack Overflow users link it as the starting point for VBA code that generates Word documents from Excel data, often when they then adapt the code and hit errors.
Recommended by 0 people across 0 different months, 2018 to 2021.
What it is
A 37-minute tutorial from the Excel For Freelancers channel showing how to use VBA to fill Word templates with data from an Excel table, replacing placeholder tags like First Name. The macro saves each letter as Word or PDF, can email through Outlook or print, and logs the template name and send date back in Excel.
What people said
Cites Dakota Sanders · 2018-07 · Stack Overflow · on “Creating Word Docs w/ Excel VBA- Insert Images? Copy and Paste Text from 3rd Doc”
I am trying to write some VBA code in excel to automate my task of building 100+ .pdf word documents, each following the set template. I originally copied a code from a youtube tutorial [this video] showing how to build automated emails from a spreadsheet, and I felt my application was similar enough. I can get the text replacements to occur as they should. My primary issue is getting images inserted where they need to be. I've attempted using a bookmark and replace code with no luck. I think my issue lies in my variables not having the correct value between the various subs, although that is only my uneducated best guess. My next issue is creating a code to pull text from an existing document an
Cites SSJErito · 2018-10 · Stack Overflow · on “Mail Merge Macro: How to send data from each row in my Excel sheet to different pages on Word?”
Thank you for your suggestions, I did however find something close to what I was looking for, here is the link for those of you that are curious to know: [this video]
Cites Jonas_Konig · 2021-04 · Stack Overflow · on “Compile error for Dim As Word.Range For Excel to Word Script”
I am following along this youtube video ( [this video] ) which allows me to write from excel to a word template. However having edited it for my needs I am getting an error early on when declaring one of the variables and I can't seem to figure out what the issue is. The code is as follows: Option Explicit Sub CreateWordDocumens() Dim CustRow, CustCol, LastRow As Long Dim DocLoc, TagName, TagValue, FileName As String Dim WordDoc As Object, WordApp As Object Dim WordContent As Word.Range With Sheet1 'Open Word Template DocLoc = Sheet1.Range("A2").Value On Error Resume Next 'If Word is already running Set WordApp = GetObject("Word.Application") If Err.Number <> 0 Then 'Launch a new instance of Word