How do you move file from mail merge to excel?

[I-Love-Math-and-Math-Loves-Me]

In my first attempt to use Mail Merge I created a long list of names,
addresses, and telephone numbers in Word. Now I need all the information in a
Excel spreadsheet and I cannot open the Mail Mergre file in Excel. Is there a
method to copy the file created in Mail Merge into Excel?.

 

[Doug Robbins - Word MVP]

Use a Directory type mailmerge main document in which you insert the merge
fields from the original data source into the cells of a one row table.
Execute the merge to a new document and then copy the table which is created
in that document and paste it into Excel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"I-Love-Math-and-Math-Loves-Me"

 

[Ashok]

Simply copy the table created in Word and paste it in the Excel file.