Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge w/ Excel Data | Microsoft Word Help | |||
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |