Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 313
- Office Version
- 365
- Platform
- Windows
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
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