Forum Discussion
Excel not generating into word templates
Aren't you using Mail Merge in Word, with Excel as the data source? The image you present of the Word template certainly fits with that hypothesis. There's no "invoke macro" involved in the Mail Merge process. That may be the disconnect, right there.
Mail Merge can be tricky at the start, so here are a couple of links to help you research the "how to". You might also find some helpful videos on YouTube
mathetes sorry no, I need to invoke macro in order to generate the documents using the information provided in the excel sheet. I click ' invoke macro' then generate the documents then print, preview, then go to the word document that pops up at the bottom and usually the information populates over, as seen in the screenshot provided, the information isn't populating over. There is a disconnect somewhere. I need someone to remote access my computer and see where the disconnect is. Is there a way to help me through quick assist?