Hello,
Seem to have fallen foul of the initial posting and in an attempt to post had to delelte most of what i wrote...



Anyway, getting back on point.


I have an excel form with headings and over 3,000 entries in rows. Data from some of those fields are in text and numbers and I want to put that data into a saved .docm template and save as a .docx as there is other data to add, but the creation of the intial document will complete about 70% of my workload. I knew that this can be done with word, but kept hitting issues with my code. I have since doing research found that excel also has the function to push data to word and seems to be noted and better supported.


I want to put the data from the excel cells into a CC .docm and save it with TWO text ref from the excel fields e.g. REF/LOCATION (LONESN12345 Chingford Green.Docx). I have found some excellent code which was on this site from gmayor and I am trying to understand what goes where and how.



Going back to basics and relearning VBA will take me more time that I am trying to save (age related brain storage issues), so any assistance would be greatly appriciated.