Reply
 
Thread Tools Display Modes
  #1   Report Post  
Edith F
 
Posts: n/a
Default Is there a way to export from mail merge to excel?

I have a list of contacts that I created in mail merge which I would like to
use to create an Excel worksheet. Is there a way to export from mail merge
to Excel?
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

You could try Graham Mayor's article at

http://www.gmayor.com/convert_labels...mail_merge.htm

When you get to the point where you have created a table, you can use
Edit|Copy in Word and Edit|Paste in an empty Excel sheet. You may need to
get rid of some of the table formatting after that.

However, if you need each column to correspond to a particular item in the
address (e.g. county, postcode etc.) then you would have to do more than
that (probably edit by hand), unless your addresses all follow exactly the
same pattern, e.g. the U.S. pattern of Street, then City, State Zip

Peter Jamieson
"Edith F" wrote in message
...
I have a list of contacts that I created in mail merge which I would like
to
use to create an Excel worksheet. Is there a way to export from mail
merge
to 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
Mail Merge w/ Excel Data PFLY Microsoft Word Help 2 May 5th 05 04:17 PM
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi Los Mailmerge 1 May 4th 05 02:52 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 06:06 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"