publisher 2000 mail merge

E

erin

I have a list of approx. 1500 names and addresses on an
excel spreadsheet that I would like to mail merge directly
with our brochures in publisher. When I try to do this, I
get an error message that says my "data source has more
than one worksheet/table." Am I s.o.l. because my list is
so long, or is there another way to do this?
 
R

Ron Cohen

Instead of attempting to use the Excel spreadsheet directly, you will have
better luck if the data is exported to a CSV file. Mail merge doesn't seem
to choke on the data as it does sometimes with Excel.
 
E

Ed Bennett

After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from erin said:
thanks ron...i am not so computer saavy...what is a CSV
file?
Click to expand...

Comma Separated Values
It is one of the options in File > Save as... in Excel
 
°

°°°MS°Publisher°°°

CSV is also referred to in some MS applications as 'Text and Commas' which
is the same thing.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Printing Mail Merge Slow 0
Mail Merge query 1
Mail Merge skipping records/sending one at a time 0
Grouping Names in Mail Merge 0
A way to mail merge from excel into a word label template? 0
Set up and printing a 4-up mail merged postcard 0
How do I mailmerge ALL addresses from Excel to Publisher? 1

Top