How do you move file from mail merge to excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

I-Love-Math-and-Math-Loves-Me - 11 Jan 2006 01:04 GMT

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?.

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2006 04:53 GMT

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.

Signature

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

> 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?.

Reply to this Message

Ashok - 18 May 2007 13:12 GMT

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

> 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?.

Reply to this Message