#1
|
|||
|
|||
Excel data using mailmerge issue
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 |
#2
|
|||
|
|||
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 |
#3
|
||||
|
||||
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] |
#4
|
|||
|
|||
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 |
#5
|
||||
|
||||
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] |
#6
|
|||
|
|||
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.. :-( |
#7
|
||||
|
||||
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] |
#8
|
|||
|
|||
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". |
#9
|
||||
|
||||
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] |
#10
|
|||
|
|||
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 |
#11
|
||||
|
||||
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] |
#12
|
|||
|
|||
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 |
#13
|
||||
|
||||
Hi Kilosub,
Go to page 4 where you see: Code:
«State» «City» «Representative» «Sales» ¶
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MailMerge with excel DDE is not retuning all of the columns | dkalsow | Mail Merge | 1 | 04-21-2011 02:18 PM |
Excel 07-Access 03 Data Link Issue | ddw23 | Excel | 0 | 08-20-2010 09:05 AM |
Excel 2003 formatting issue when moving to new WB | aramsey | Excel | 2 | 04-22-2010 02:34 PM |
CHALLENGE! Issue sorting data containing relative references on a separate tab | lax828 | Excel | 3 | 01-07-2010 11:28 AM |
Icon issue with Office 2000 data files | bankboysb | Office | 0 | 01-24-2006 10:23 AM |