Mailmerge into Word from Multiple Excel CSV's

[FrankBooth]

Hello,

I'm totally new to this mail merge thing.

I can do a simple Mailmerge in Word using an Excel CSV, for mailing
labels. However, I'd like to be able to automate it so that I don't
have to do a separate merge for every CSV (and I have lots) in a
folder.

Would someone please point in me in the right direction as to how
would be able to do this?

Thanks very much in advance for any help.

--FB

 

[Cindy M -WordMVP-]

Hi FrankBooth,

We need some more background information

1. Which version of Word is involved?

2. Why are you merging to a csv, rather than directly to the Excel
workbook?

3. Are these data files all being merged into the same merge
document? If yes, why wouldn't you combine them into one file?

4. Please list the steps you currently follow to merge more than one
csv, so that we have an idea of what you're trying to automate.

I'm totally new to this mail merge thing.

I can do a simple Mailmerge in Word using an Excel CSV, for mailing
labels. However, I'd like to be able to automate it so that I don't
have to do a separate merge for every CSV (and I have lots) in a
folder.

Would someone please point in me in the right direction as to how
would be able to do this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[FrankBooth]

Thanks for answering!

1: I have Word 2002 (v10) Sp1

2: I am merging from a CSV in excel into a Labels doc in Word. I have
many separate CSV files (ALL exactly alike) from which I want to pull
Address data to fill the labels automatically. If I can do this in
Excel without using Word then please tell me how.

3: Yes I want to merge them into one labels document. The source of
this data makes it so That I have to download a chunk of data at a
time thereby my need to create separate CSV's. (I don't know if
there's a way in Excel to merge all these together into one large CSV.
If there is, I'd like to know.

4: All I'm doing now is merging one CSV at a time using the Word's
Merge Wizard. I'd like to know if there is a way to merge all my CSV's
using some kind of script or automation, etc...

Thanks again for all your help.

--FB

 

[Cindy M -WordMVP-]

Hi FrankBooth,

thanks for the additional information...

2: I am merging from a CSV in excel into a Labels doc in Word. I have
many separate CSV files (ALL exactly alike) from which I want to pull
Address data to fill the labels automatically. If I can do this in
Excel without using Word then please tell me how.

We're still not on the same wave-length, here. An Excel file is *.xls;
a *.csv file is usually a comma-delimited text file? But such a file
cannot be an Excel file. It could be exported/imported from/into Excel,
but it's not Excel. So I really need to know if these are Excel
spreadsheets, or comma-delimited text files?

As to your specific question, if you can somehow pull together separate
files and use them for a single mail merge, the answer is decidedly,
"No, you cannot".

Given what I understand you have, a possible solution would be to
insert/link all these files, one after another, into an Excel
spreadsheet and use that as the data source. Best to ask in an Excel
newsgroup how best to go about this.

OR to create one large CSV file, by appending one after the other
(using VB or VBA code, for example).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail