User form with mail merge functionality

[johnj81]

Hi Excel Community,

I'm trying to create a User form that will take data from a spreadsheet and populate a word document template (already created) with specified data, based on the user input. Not sure if that made sense. For example, I have a list of customers on a spreadsheet with all their info (Name|Address|Phone...). I need the user to be able to type the customer ID inside a text box on the form then have a button click event procedure generate & save that file to a specified folder. Each row (aside from the header row) represents 1 customer. I realize this is a lot to ask, but I'm still a bit novice with VBA and would really appreciate some help on how I can approach this. Again any help would be greatly appreciated! Thanks.

 

[03aviator]

This sounds a lot like what I am trying to do... I have an excel file with rows filled with names, addresses, and dates that I would like to feed (mail merge) into a Word template and create a separate letter for each row of data in the excel file.

Anyone out there able to help? I am more or less a novice with VBA.