Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
I-Love-Math-and-Math-Loves-Me
 
Posts: n/a
Default How do you move file from mail merge to excel?

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?.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default How do you move file from mail merge to excel?

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"
wrote in message
...
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?.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ashok Ashok is offline
external usenet poster
 
Posts: 6
Default How do you move file from mail merge to excel?

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

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

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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using HTML file as data source for Mail Merge thenin Mailmerge 4 November 21st 05 08:03 AM
cannot mail merge from excel to word Alan Mailmerge 3 October 26th 05 05:03 AM
Mail Merge does not accept formatted cell of Excel Freny Mailmerge 1 August 18th 05 04:46 AM
Mail merge from excel file to produce labels for mass mailing Jeanie Mailmerge 4 January 27th 05 11:55 AM
How to attach a PDF file to a Mail Merge Email from Word? RPMissions Mailmerge 1 January 16th 05 07:06 AM


All times are GMT +1. The time now is 02:51 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"