Hi All,



I'm not sure how to explain it but will try my best. I have data in excel and need to be port to MS Words and use mailmerge to print it. The issue is it's needs to do a check, if company A has multiple transaction then print all if more than 15 transactions. Print 1st page with 10 transaction and the rest at 2nd page with the header information as per normal as 1st page.

Thanks and cheers!!

Kilosub

Hi All,

Attach here is the dummy data and the desire of the output format..

Please let me know if it can be done or should this issue be move to mailmerge category.


Thanks and cheers!!

Kilosub

Attached Files

	Dummy Data (input).xls (59.5 KB, 19 views)
	Dummy Output.doc (35.5 KB, 17 views)

Hi kilosub,

You can do that kind of thing with Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod,

Thanks for the documentation. I went thru till page 4 now. Under "Merge records by category" I manage the output result on the top 1st record or should it be extract all data from excel.

Thanks and cheers!!

Kilosub

Hi Kilosub,

Did you examine the field code in the tutorial and use it with the sample mailmerge main document & excel workbook supplied?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod,

Yes, I'm using the sample mailmerge main document and excel workbook supplied. Where should I declare 'SET Key = "" '.

Sorry, I'm very new with this mailmerge,macro and VB thing.. :-(

Hi Kilosub,

There's no 'vb' to worry about for the examples you're working with. It's all done with field coding, and the 'Key' field is defined in the field code. If you examine the field code in the tutorial (you can copy the field to the sample mailmerge main document for use with the Excel file), that will become evident.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod,

There's this error message when I frist open the sample mailmerge main document, "Opening this document will run the following SQL command *Select Catalogue Merge Data.xls data from your database will be place in the document. Do you want to continue?" Should i hit "Yes"or "No".

Hi Kilosub,

That's not an error message - it's a standard mailmerge prompt. And yes, you need to let it run the query; otherwise the file will cease to be a mailmerge main document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod,

I still cannot get around the field code thing. Sorry for my limited knowledge... :-(

I don't understand the quote"The first IF field in each example initializes an empty 'Key' bookmark, via ' SET Key = "" '." This set key thing should be copy in excel or word.

Attach is the test run. Hope you can guide me thru..

Thanks and Cheers!!

Kilosub

Attached Files

Mailmerge Main Document.doc (32.0 KB, 14 views)

Hi Kilosub,

I don't see any fields from the tutorial in that document! The fields are fields that you've input, not the fields from the tutorial...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod,

lol, I'm going to take a break for awhile... getting no where at this moment.

Btw, fields as refer as the data or the header in excel?

Is it that I need to put something in this line {MERGEFIELD City}?


Thanks and Cheers!!

Kilosub

Hi Kilosub,

Go to page 4 where you see:
You have to copy the whole of that range - it's all one big field wth lots of other fields inside, which you will see if youy select it and press Shift-F9 - then paste it into the mailmerge main document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]