Create a document based on Excel Data

[Pestomania]

Hey all,

I am trying to identify a way to generate a word document based on excel data.

If I have 20 lines of data, I'd like to be able to add 20 table rows in word that are formatted and all data is present.

But if I have 8 lines of data, I'd only want to see 8 table rows. I couldn't get a mail merge to work since it requires mapped fields and a document generator in pdf doesn't work for the same reason.

Is there a way to do this via excel / word or would this be easier accomplished via smartsheet, Python, R, etc?

Thank you

 

[NdNoviceHlp]

Hi Pestomania. You can review this link to see if it will help. Dave

VBA/Macros help for an Excel to Word document generator. Need to create and find/replace X tables, where X is the numberof rows TRUE in another sheet

Hi Excel brains trust, My company have created a Report generator using a spreadsheet + VBA/macros. To use it, our employees fill in a row, select a template from a dropdown, enter the reference pertaining to it, and then click a "Create Document" button. The code then reads which template is...

www.mrexcel.com