Print 100 pages with data change of each pahe

[tran1728]

Dear ALL, thans for your help.

I want print 100 pages for my supply with idem letter,
but the store, Po and Qty changed of each page .

Exemple :
Data in the sheet
A B C
Store Po QTy
A1 202 25865 24 for page 1
A2 256 24899 25 for page 2
A3 285 25732 54 for page 3

My Lettre

Dear Director,
To: 202
PO : 25865
QTY : 24

I want print 3 pages with the date changed of each page.
Please thanks for your help.






Then Print 3 pages




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1-9dc0b3cc1bf1&dg=microsoft.public.excel.misc

 

[Dave Peterson]

Saved from a previous post:

Lots of times, it's easier to use MSWord for printing and Excel (or some other
database application) as the source.

You may want to read some tips for mailmerge.
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.

And if you notice problems with the formatting of data (like zipcodes)...

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

======================================
If you can't figure out how to use multiple dates in the mailmerge, you can ask
in an MSWord forum. Or you could insert a date column, repeat your data twice
more and use that field.

============

If you wanted to keep it completely within excel, you could use the technique at
Debra Dalgleish's site:

http://contextures.com/xlForm03.html

You'll either need to adjust the code for the 3 dates or add that extra field
with the multiple dates.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

 

[tran1728]

Dear Dave Peterson,
Thank you very much, that's exactly what I want,
mailmerge in word

Thanks again