Text printing from VBA Excel macro

[ben]

Hi,

I'd like to print letters on my printer using a general text with holes
in it that would contain values from cells in my Excel spreadsheet. (A
sort of mailing).

It would be great if my text could depend on my cells

Example :
Aux Parents de François
or
Aux Parents d'Isabelle

François and Isabelle would be values from cells

I could program a macro to do the difference between ( d' ) and ( de )

Excuse my poor language, but I speak French
Thank you

 

[Dave Peterson]

If your excel data looks like a table (one row per entry), then you could use
mailmerge within MSWord for creating nice form letters.

Here's a couple of links that might come in handy:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.