Taking Data in Excel and Putting it in Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreadsheet that I use for scheduling. Every couple of months I copy the information into a Word document. What I was wondering is if I could automate this task by creating a button that I push that will automatically ask me what the date range is and then print the information into a Word document. For instance, column A is Dates, B is Person's Name, C is Department and D is Task. I just wanted to have that automatically populate a Word document based on the date range (beginning and ending), similar to a Crystal Report or other report writing tool. When I try to use Mail Merge in Word and Excel as the Data Source, all I get as choices are AutoMergeField and AutoMergeField2. There does not seem to be enough merge fields to use. (I have named the columns in Excel.
Is there a better way of doing this? Can it be done the way I am trying it
Any help would be appreciated
Thanks
Sean
 
Back
Top