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" <I-Love-Math-and-Math-Loves-Me[ at ]discussions.microsoft.com> wrote in message news:3CFEBA7F-08FC-4F45-9D01-274A92BE659A[ at ]microsoft.com...
[Quoted Text] > 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?.
|