Help with Excel To Word Links

[Harvey12]

Hello Excel Wiz - Kids,

I am currently trying to make links between Excel and Word. I have a file in excel which is essentially in a table format (Not pivot table or chart, just set out like a table), and I have a word document which is basically a form of this data, I am hoping I can use the data in Excel to populate the form instead of doing this manually. I can provide a sample document of both files to anyone who is happy to help. I have provided just a simple C+P of example data from the table in Excel:

[TABLE="width: 1110"]
<tbody>[TR]
[TD]Booking ID[/TD]
[TD]Status[/TD]
[TD]Customer Name[/TD]
[TD]Start[/TD]
[TD]Nights[/TD]
[TD]Accommodation Name[/TD]
[TD]Unit Code[/TD]
[TD]Adults[/TD]
[TD]Children[/TD]
[TD]Infants[/TD]
[TD]Pets[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11111111[/TD]
[TD]Confirmed[/TD]
[TD]Mr Harold James[/TD]
[TD="align: right"]04/09/2017[/TD]
[TD="align: right"]7[/TD]
[TD]Kingham Plus Lodge[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]12111111[/TD]
[TD]Confirmed[/TD]
[TD]Mrs Debra Gerald[/TD]
[TD="align: right"]04/09/2017[/TD]
[TD="align: right"]4[/TD]
[TD]Cupid's Lodge[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]12222223[/TD]
[TD]Confirmed[/TD]
[TD]Mr James Smith[/TD]
[TD="align: right"]04/09/2017[/TD]
[TD="align: right"]7[/TD]
[TD]Cupid's Lodge[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]15696669[/TD]
[TD]Confirmed[/TD]
[TD]Mr Shaun Master[/TD]
[TD="align: right"]04/09/2017[/TD]
[TD="align: right"]4[/TD]
[TD]Romeo Lodge[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]13300981[/TD]
[TD]Confirmed[/TD]
[TD]Mr James Hunter[/TD]
[TD="align: right"]04/09/2017[/TD]
[TD="align: right"]4[/TD]
[TD]Kingham Lodge[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

What I am hoping to achieve is to understand how to make links between Excel & Word and what steps I need to follow to achieve this!

Thanks Guys!

 

[Macropod]

It's not clear from your post what you're trying to achieve.

If you're trying to create form letters, etc., where each row from Excel creates a separate Word letter or mailing label, for example, you'd use Word's mailmerge tools. For the basics, see:
Use mail merge to create and send bulk mail, labels, and envelopes - Word

Alternatively, if all you're trying to do is to link a Word document to an Excel table, that could be done by copying the Excel range and pasting it into Word with Paste Special, using the 'paste link' option and your preferred paste format.

 

[Harvey12]

Hi Macropod,

Sorry for the confusion - if I'm quite frank, I wasn't 100% sure what to ask for I want each row to create it's own document - therefore I will look at that link you posted, thank you very much