[OS X TeX] Mail merge from Excel to LaTeX letter class?
Andrei Sobolevskii
ansobol at gmail.com
Fri Oct 31 03:04:25 EDT 2008
Dear Mike,
On 31 Oct 2008, at 05:52, Michael Hanson wrote:
> I have an existing Excel worksheet with contact information that I'd
> like to "mail merge" into a set of LaTeX-generated letters.
> Ideally, I'd like to be able to just push a button in TeXShop and
> have this work -- maybe a macro or engine? I'm willing to learn
> some basic coding to facilitate a relatively automated solution
You might first export your Excel file into CSV format (CSV means
"comma separated values"; since fields in your file probably contain
commas, choose some other delimiter, e.g. tab) and then process it
with some tool. E.g. you could write a shell script or a simple C
program that scans the CSV file and writes out the LaTeX documents.
Alas, I don't use Excel myself so this is about all I could say.
Others will no doubt have more useful suggestions.
HTH
Andrei
More information about the MacOSX-TeX
mailing list