Mail Merges

Carole · Apr 3rd, 2002, 04:37 AM

Can you tell me how to get data from a spreadsheet in to a word document. The spreadsheet has been filtered to only show items due in the month of May. My colleague and I have tried and we either get all of the spreadsheet data or none (data source is empty message?)

steven H · Apr 3rd, 2002, 04:47 AM

Copy the filtered results to a new worksheet,name it mail merge, save, open word 'tools' mail merge, choose document,choose data source(your excel file)choose the work sheet 'mail merge', add the fields you want to the word document, save as new document or to printer.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 04:37 AM	#1
Carole New Member Join Date: Apr 2002 Location: Carole Posts: 8	Can you tell me how to get data from a spreadsheet in to a word document. The spreadsheet has been filtered to only show items due in the month of May. My colleague and I have tried and we either get all of the spreadsheet data or none (data source is empty message?)

Apr 3rd, 2002, 04:47 AM	#2
steven H Board Regular Join Date: Feb 2002 Location: Liverpool UK Posts: 66	Copy the filtered results to a new worksheet,name it mail merge, save, open word 'tools' mail merge, choose document,choose data source(your excel file)choose the work sheet 'mail merge', add the fields you want to the word document, save as new document or to printer.