Creating a Word Mail-Merge doc from Excel

J

Joel Borden

Hi -

I have an Excel 2003 workbook, and from within it (using VB), I would
like to create a new Word doc, make it a Mail-Merge doc (for labels)
using the data in my spreadsheet, format the labels, etc.

I have been able to pull the data from an Access database, do the
manipulation I need to make it look right, and now I need to
mail-merge it out. For a whole bunch of reasons, I can't do the whole
thing in Access.

I seem to be getting close, but I can't make the various code snippets
I've found play nicely together. Does anyone have any experience with
something like this?

Thanks in advance for any light you can shed!


Joel Borden
[email protected]
 
Top