ideasfactory
New Member
- Joined
- Aug 22, 2013
- Messages
- 38
Hi,
I want Excel to create a word doc based on a .dot that is populated with data from excel, most importantly I need one word doc per row or record from excel.
I have 4 columns in excel:
<tbody>
</tbody>
I have a word .dot that has areas throughout the document where I want to populate the 4 columns of data above. For example on page 1 I want ID in a specific location, on page 2 I want Title and Name and on Page 3 I want Address.
I want to save a word document .doc with the ID and Title as the filename.
The end result in this example would be four word .doc with page 1 ID in a specific location, on page 2 Title and Name and on Page 3 Address.
Does anyone know how to achieve this with VBA? I have investigated Mail Merge but does not create separate word docs only creates them in the single document.
Thanks
I want Excel to create a word doc based on a .dot that is populated with data from excel, most importantly I need one word doc per row or record from excel.
I have 4 columns in excel:
ID | Title | Name | Address |
FY1718-824 | Initiative Name1 | Lisa | Address1 |
FY1718-627 | Initiative Name2 | Craig | Address2 |
FY1617-345 | Initiative Name3 | Ben | Address3 |
FY1617-450 | Initiative Name4 | Elizabeth | Address4 |
<tbody>
</tbody>
I have a word .dot that has areas throughout the document where I want to populate the 4 columns of data above. For example on page 1 I want ID in a specific location, on page 2 I want Title and Name and on Page 3 I want Address.
I want to save a word document .doc with the ID and Title as the filename.
The end result in this example would be four word .doc with page 1 ID in a specific location, on page 2 Title and Name and on Page 3 Address.
Does anyone know how to achieve this with VBA? I have investigated Mail Merge but does not create separate word docs only creates them in the single document.
Thanks