macro button to open word document and use data.

New Contributor

Hi all,


PC using Office 365.


I want to have 4 or 5 macro buttons that open various word documents and automatically have the data from the sheet available (just edit recipients list). Currently have the buttons set up but when the word document opens I then have to go into select recipients and use existing list to find the data source. 


I assume this is a visual basic rework but I would have no idea how to do that. 


I know this is vague but any help to put me into the right direction would be much appreciated. 

0 Replies