Macro to Pull Excel Data into Word Document

**jlo33** · 03-28-2024, 03:27 PM

I'm wanting to create a macro where when it is run, it will copy data located in one specific excel sheet into a word document.

Any guidance would be appreciated.

**Kaper** · 03-28-2024, 03:35 PM

A little bit more about the idea and what are you trying to obtain?

Because at first glance it seems to be the task just for mailmerge functionality of Word.

By the way - are you still using Excel 2007? if not it would be a good idea to update your profile.

**jlo33** · 03-28-2024, 03:48 PM

One of the pages of my excel doc contains a report of sorts (pulling data from other worksheets). I need to pull it to be able to put it quickly into a word document to send a report off to a committee.

Thanks for the reminder... I'm using Microsoft 365.