Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text printing from VBA Excel macro
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Macro for Excel 97 | Excel Discussion (Misc queries) | |||
excel extended text printing | Excel Discussion (Misc queries) | |||
Printing Problem In Excel Due to Macro? | Excel Discussion (Misc queries) | |||
Printing Problems in Excel due to a Macro in Word?! | Excel Discussion (Misc queries) | |||
Getting zoom ratio (printing) in Excel macro | Excel Programming |