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:

Booking ID	Status	Customer Name	Start	Nights	Accommodation Name	Unit Code	Adults	Children	Infants	Pets
11111111	Confirmed	Mr Harold James	04/09/2017	7	Kingham Plus Lodge	1	2	2	0	0
12111111	Confirmed	Mrs Debra Gerald	04/09/2017	4	Cupid's Lodge	4	2	0	0	0
12222223	Confirmed	Mr James Smith	04/09/2017	7	Cupid's Lodge	5	2	0	0	0
15696669	Confirmed	Mr Shaun Master	04/09/2017	4	Romeo Lodge	7	2	0	0	0
13300981	Confirmed	Mr James Hunter	04/09/2017	4	Kingham Lodge	9	3	0	0	0

<tbody>
</tbody>

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