How Might I "Mail Merge" Data For Multiple .txt File Output?
 

Instead of mail merging a list of addresses with a letter, my goal is
to combine a list of data with a text file (actually an .XML script) to
make a number of seperate .txt files, each with one of the data lines
imbedded.

One could concievably do this in a straightforward way in MS Word,
except that Word will let you send output either to a printer, to
email, or to a SINGLE large output file. I want to crank out dozens of
individual text files, one for each member of the input data file.

I am an avid Excel user, but, ahem, a very poor macro programmer.
Could you suggest a macro script that would run this mail-merge-like
function?

How Might I "Mail Merge" Data For Multiple .txt File Output?
 

You might find some help at Ron's site.

http://www.rondebruin.nl/sendmail.htm

" wrote:

Instead of mail merging a list of addresses with a letter, my goal is
to combine a list of data with a text file (actually an .XML script) to
make a number of seperate .txt files, each with one of the data lines
imbedded.

One could concievably do this in a straightforward way in MS Word,
except that Word will let you send output either to a printer, to
email, or to a SINGLE large output file. I want to crank out dozens of
individual text files, one for each member of the input data file.

I am an avid Excel user, but, ahem, a very poor macro programmer.
Could you suggest a macro script that would run this mail-merge-like
function?

How Might I "Mail Merge" Data For Multiple .txt File Output?
 

If you already have a text file, you can use low level file io to read it
in, then loop through your data and write out a similar file, inserting the
appropriate additional line.

http://support.microsoft.com/default...b;en-us;151262
Working with Sequential Access Files

http://www.applecore99.com/gen/gen029.asp

http://web.archive.org/web/200404050...eio/fileio.asp
File Access with Visual Basic® for Applications

http://pubs.logicalexpressions.com/P...cle.asp?ID=622

You can also use the scripting runtime (Textstream object)

http://msdn.microsoft.com/library/de...0800ad34d6.asp


--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Instead of mail merging a list of addresses with a letter, my goal is
to combine a list of data with a text file (actually an .XML script) to
make a number of seperate .txt files, each with one of the data lines
imbedded.

One could concievably do this in a straightforward way in MS Word,
except that Word will let you send output either to a printer, to
email, or to a SINGLE large output file. I want to crank out dozens of
individual text files, one for each member of the input data file.

I am an avid Excel user, but, ahem, a very poor macro programmer.
Could you suggest a macro script that would run this mail-merge-like
function?

How Might I "Mail Merge" Data For Multiple .txt File Output?
 

Tom, JLGWhiz; thanks so much for your input!

Tim