View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Text printing from VBA Excel macro

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.

ben wrote:

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

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/


--

Dave Peterson