Excel to word automation

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

Unsolved

Post Body

Hi all

Looking for some guidance on the following scenario.

Being able to automate the extraction of information from the excel sheet on to the Word doc. All the information needs to be extracted. A large amount of letters (on word) will be sent out templated with certain parts being populated from the excel spreadsheet

We have a list of data rows/columns on excel that needs to be populated onto a word document template.. example. The letter needs to populate the following fields below from an excel spreadsheet.

Address:

[Addr1]

[PostCode]

[Addr2]

[PostCode]

I'm wondering what is the best way to tackle this task?

Author

Account Strength

100%

Account Age

11 years

Verified Email

Yes

Verified Flair

Yes

Total Karma

431

Link Karma

159

Comment Karma

272

Profile updated: 19 hours ago

Posts updated: 4 hours ago

elimelim

Subreddit

r/vba

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 5 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/vba/comment...