How do I get an existing mail merge address list into a standalone Excel
spreadsheet with the same column names as address list headings. I then want
to be able to add my own columns to the Excel spreadsheet and have formulas
on columns etc.

This group is for Word issues. If it is a Word list you are talking about,
see http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Jimbo Mi wrote:
How do I get an existing mail merge address list into a standalone
Excel spreadsheet with the same column names as address list
headings. I then want to be able to add my own columns to the Excel
spreadsheet and have formulas on columns etc.

Where it it presently? You can create a table containing the records by
using a directory type mailmerge maindocument in which you have the
mergefields in the cells of a one row table. When you execute that merge
to a new document, you will get a table containing the data for each record.
You can insert a row at the top of the table into which you insert the
mergefield names and you can modify/use that as a data source or copy and
paste it into Excel and modify/use it there as the datasource.

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

How do I get an existing mail merge address list into a standalone Excel
spreadsheet with the same column names as address list headings. I then
want
to be able to add my own columns to the Excel spreadsheet and have
formulas
on columns etc.