Taking Data in Excel and Putting it in Word

[Sean]

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

 

[Debra Dalgleish]

To merge with a Word document, your Excel data must be in a table. David
McRitchie has instructions on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Also, there's information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm