Hello Excel Experts,
I have a new inquiry that has do to with copying data from an Excel file to a Word document, I already figured out how to do it but what I Need after it is something more complicated that I cannot figure out how to do, I have searched through the Forum and have not found Information about it.
I need to inform our Partners that our address has changed, so I created a Word template with all the Information and left a blank space for the Name and address of the Partner I want to inform about this change.
On the other hand, I have an Excel file with 2 columns, Name and Address (columns B and C ) and Information starts at B3 and C3. There are around 250 Partners that need to be informed about this change by regular mail. 250 does not Sound as a big number, but it is just a test because it could be used for more than 2000.
So my question is, is there a way using a VBA Macro to:
(1)Open the Word document, (2) copy Name and Address from the Excel list in the blank space in the Word document, (3) paste it in the Word document, (4) save and Close Word Document (Ideally the file Name should be the Company Name that it will be sent to) and repeat for each line until there are no lines left.
I know it sounds Kind of weird, however any help would be greatly appreciated, thank you in advance.
Jorge
Bookmarks