Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Macro for Excel 97 dhstein Excel Discussion (Misc queries) 0 April 27th 09 05:26 PM
excel extended text printing beussg Excel Discussion (Misc queries) 1 December 19th 08 08:11 PM
Printing Problem In Excel Due to Macro? [email protected] Excel Discussion (Misc queries) 4 March 20th 07 04:05 PM
Printing Problems in Excel due to a Macro in Word?! [email protected] Excel Discussion (Misc queries) 0 March 15th 07 04:13 PM
Getting zoom ratio (printing) in Excel macro Stephen[_4_] Excel Programming 0 September 23rd 03 11:27 AM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"