• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

Mail merge summarise

R

RKS

Flightless Bird
Hi
I have large excel file like that.

company invoice no date amount
abc 1234 05/05/09 40000.00
kpc 2534 05/05/09 30000.00
abc 1256 05/07/09 50000.00
kpc 1987 03/05/09 60000.00
abc 1526 05/07/09 70000.00
tino 71234 15/05/09 80000.00
abc 8234 08/05/09 90000.00
tino 1200 05/09/09 12000.00
abc 1299 05/11/09 35000.00
tino 1288 05/07/09 67000.00
abc 1554 15/02/09 74000.00

I m using Mail merge in office 2003 and send the letter to company his
detail. i m using mail merge option. I get only one record to each letter
while i wants send to letter to company thru detail like that.

anyone please help me urgently. It is possible or not.


I wants output like that....

Dear SIr

Please find attached ur statement

abc 1234 05/05/09 40000.00
abc 1256 05/07/09 50000.00
abc 1526 05/07/09 70000.00
abc 8234 08/05/09 90000.00
abc 1299 05/11/09 35000.00
abc 1554 15/02/09 74000.00


Dear SIr

Please find attached ur statement

kpc 2534 05/05/09 30000.00
kpc 1987 03/05/09 60000.00



Dear SIr

Please find attached ur statement
tino 71234 15/05/09 80000.00
tino 1200 05/09/09 12000.00
tino 1288 05/07/09 67000.00

thanks
RKS
 
M

macropod

Flightless Bird
Hi RKS,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how, check
out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
http://lounge.windowssecrets.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.


--
Cheers
macropod
[Microsoft MVP - Word]


"RKS" <RKS@discussions.microsoft.com> wrote in message news:A6C83EB6-DC56-4930-A584-8A703786AEF2@microsoft.com...
> Hi
> I have large excel file like that.
>
> company invoice no date amount
> abc 1234 05/05/09 40000.00
> kpc 2534 05/05/09 30000.00
> abc 1256 05/07/09 50000.00
> kpc 1987 03/05/09 60000.00
> abc 1526 05/07/09 70000.00
> tino 71234 15/05/09 80000.00
> abc 8234 08/05/09 90000.00
> tino 1200 05/09/09 12000.00
> abc 1299 05/11/09 35000.00
> tino 1288 05/07/09 67000.00
> abc 1554 15/02/09 74000.00
>
> I m using Mail merge in office 2003 and send the letter to company his
> detail. i m using mail merge option. I get only one record to each letter
> while i wants send to letter to company thru detail like that.
>
> anyone please help me urgently. It is possible or not.
>
>
> I wants output like that....
>
> Dear SIr
>
> Please find attached ur statement
>
> abc 1234 05/05/09 40000.00
> abc 1256 05/07/09 50000.00
> abc 1526 05/07/09 70000.00
> abc 8234 08/05/09 90000.00
> abc 1299 05/11/09 35000.00
> abc 1554 15/02/09 74000.00
>
>
> Dear SIr
>
> Please find attached ur statement
>
> kpc 2534 05/05/09 30000.00
> kpc 1987 03/05/09 60000.00
>
>
>
> Dear SIr
>
> Please find attached ur statement
> tino 71234 15/05/09 80000.00
> tino 1200 05/09/09 12000.00
> tino 1288 05/07/09 67000.00
>
> thanks
> RKS
>
 
R

RKS

Flightless Bird
Hi macropod
Thanks for ur reply

see ur reply in zip format but i cant get how to set key filed
please clearify easy ways so i can do

Thanks
RKS


"macropod" wrote:

> Hi RKS,
>
> You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how, check
> out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
> http://lounge.windowssecrets.com/index.php?showtopic=731107
> or
> http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
> Do read the tutorial before trying to use the mailmerge document included with it.
>
>
> --
> Cheers
> macropod
> [Microsoft MVP - Word]
>
>
> "RKS" <RKS@discussions.microsoft.com> wrote in message news:A6C83EB6-DC56-4930-A584-8A703786AEF2@microsoft.com...
> > Hi
> > I have large excel file like that.
> >
> > company invoice no date amount
> > abc 1234 05/05/09 40000.00
> > kpc 2534 05/05/09 30000.00
> > abc 1256 05/07/09 50000.00
> > kpc 1987 03/05/09 60000.00
> > abc 1526 05/07/09 70000.00
> > tino 71234 15/05/09 80000.00
> > abc 8234 08/05/09 90000.00
> > tino 1200 05/09/09 12000.00
> > abc 1299 05/11/09 35000.00
> > tino 1288 05/07/09 67000.00
> > abc 1554 15/02/09 74000.00
> >
> > I m using Mail merge in office 2003 and send the letter to company his
> > detail. i m using mail merge option. I get only one record to each letter
> > while i wants send to letter to company thru detail like that.
> >
> > anyone please help me urgently. It is possible or not.
> >
> >
> > I wants output like that....
> >
> > Dear SIr
> >
> > Please find attached ur statement
> >
> > abc 1234 05/05/09 40000.00
> > abc 1256 05/07/09 50000.00
> > abc 1526 05/07/09 70000.00
> > abc 8234 08/05/09 90000.00
> > abc 1299 05/11/09 35000.00
> > abc 1554 15/02/09 74000.00
> >
> >
> > Dear SIr
> >
> > Please find attached ur statement
> >
> > kpc 2534 05/05/09 30000.00
> > kpc 1987 03/05/09 60000.00
> >
> >
> >
> > Dear SIr
> >
> > Please find attached ur statement
> > tino 71234 15/05/09 80000.00
> > tino 1200 05/09/09 12000.00
> > tino 1288 05/07/09 67000.00
> >
> > thanks
> > RKS
> >
>
> .
>
 
M

macropod

Flightless Bird
Hi RKS,

The details are set out clearly on page 1 of the tutorial. The examples on the following pages show how the key field is used.

--
Cheers
macropod
[Microsoft MVP - Word]


"RKS" <RKS@discussions.microsoft.com> wrote in message news:ACD3114D-CD2E-4D46-85AC-10B2B3AE0AF1@microsoft.com...
> Hi macropod
> Thanks for ur reply
>
> see ur reply in zip format but i cant get how to set key filed
> please clearify easy ways so i can do
>
> Thanks
> RKS
>
>
> "macropod" wrote:
>
>> Hi RKS,
>>
>> You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how,
>> check
>> out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
>> http://lounge.windowssecrets.com/index.php?showtopic=731107
>> or
>> http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
>> Do read the tutorial before trying to use the mailmerge document included with it.
>>
>>
>> --
>> Cheers
>> macropod
>> [Microsoft MVP - Word]
>>
>>
>> "RKS" <RKS@discussions.microsoft.com> wrote in message news:A6C83EB6-DC56-4930-A584-8A703786AEF2@microsoft.com...
>> > Hi
>> > I have large excel file like that.
>> >
>> > company invoice no date amount
>> > abc 1234 05/05/09 40000.00
>> > kpc 2534 05/05/09 30000.00
>> > abc 1256 05/07/09 50000.00
>> > kpc 1987 03/05/09 60000.00
>> > abc 1526 05/07/09 70000.00
>> > tino 71234 15/05/09 80000.00
>> > abc 8234 08/05/09 90000.00
>> > tino 1200 05/09/09 12000.00
>> > abc 1299 05/11/09 35000.00
>> > tino 1288 05/07/09 67000.00
>> > abc 1554 15/02/09 74000.00
>> >
>> > I m using Mail merge in office 2003 and send the letter to company his
>> > detail. i m using mail merge option. I get only one record to each letter
>> > while i wants send to letter to company thru detail like that.
>> >
>> > anyone please help me urgently. It is possible or not.
>> >
>> >
>> > I wants output like that....
>> >
>> > Dear SIr
>> >
>> > Please find attached ur statement
>> >
>> > abc 1234 05/05/09 40000.00
>> > abc 1256 05/07/09 50000.00
>> > abc 1526 05/07/09 70000.00
>> > abc 8234 08/05/09 90000.00
>> > abc 1299 05/11/09 35000.00
>> > abc 1554 15/02/09 74000.00
>> >
>> >
>> > Dear SIr
>> >
>> > Please find attached ur statement
>> >
>> > kpc 2534 05/05/09 30000.00
>> > kpc 1987 03/05/09 60000.00
>> >
>> >
>> >
>> > Dear SIr
>> >
>> > Please find attached ur statement
>> > tino 71234 15/05/09 80000.00
>> > tino 1200 05/09/09 12000.00
>> > tino 1288 05/07/09 67000.00
>> >
>> > thanks
>> > RKS
>> >
>>
>> .
>>
 
R

RKS

Flightless Bird
Hi Macropod,

tutorial page are not clear and not in example. pls send me another solved
example so i see how i will set. pls send me other solved example.

Thanks
RKS



"macropod" wrote:

> Hi RKS,
>
> The details are set out clearly on page 1 of the tutorial. The examples on the following pages show how the key field is used.
>
> --
> Cheers
> macropod
> [Microsoft MVP - Word]
>
>
> "RKS" <RKS@discussions.microsoft.com> wrote in message news:ACD3114D-CD2E-4D46-85AC-10B2B3AE0AF1@microsoft.com...
> > Hi macropod
> > Thanks for ur reply
> >
> > see ur reply in zip format but i cant get how to set key filed
> > please clearify easy ways so i can do
> >
> > Thanks
> > RKS
> >
> >
> > "macropod" wrote:
> >
> >> Hi RKS,
> >>
> >> You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how,
> >> check
> >> out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
> >> http://lounge.windowssecrets.com/index.php?showtopic=731107
> >> or
> >> http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
> >> Do read the tutorial before trying to use the mailmerge document included with it.
> >>
> >>
> >> --
> >> Cheers
> >> macropod
> >> [Microsoft MVP - Word]
> >>
> >>
> >> "RKS" <RKS@discussions.microsoft.com> wrote in message news:A6C83EB6-DC56-4930-A584-8A703786AEF2@microsoft.com...
> >> > Hi
> >> > I have large excel file like that.
> >> >
> >> > company invoice no date amount
> >> > abc 1234 05/05/09 40000.00
> >> > kpc 2534 05/05/09 30000.00
> >> > abc 1256 05/07/09 50000.00
> >> > kpc 1987 03/05/09 60000.00
> >> > abc 1526 05/07/09 70000.00
> >> > tino 71234 15/05/09 80000.00
> >> > abc 8234 08/05/09 90000.00
> >> > tino 1200 05/09/09 12000.00
> >> > abc 1299 05/11/09 35000.00
> >> > tino 1288 05/07/09 67000.00
> >> > abc 1554 15/02/09 74000.00
> >> >
> >> > I m using Mail merge in office 2003 and send the letter to company his
> >> > detail. i m using mail merge option. I get only one record to each letter
> >> > while i wants send to letter to company thru detail like that.
> >> >
> >> > anyone please help me urgently. It is possible or not.
> >> >
> >> >
> >> > I wants output like that....
> >> >
> >> > Dear SIr
> >> >
> >> > Please find attached ur statement
> >> >
> >> > abc 1234 05/05/09 40000.00
> >> > abc 1256 05/07/09 50000.00
> >> > abc 1526 05/07/09 70000.00
> >> > abc 8234 08/05/09 90000.00
> >> > abc 1299 05/11/09 35000.00
> >> > abc 1554 15/02/09 74000.00
> >> >
> >> >
> >> > Dear SIr
> >> >
> >> > Please find attached ur statement
> >> >
> >> > kpc 2534 05/05/09 30000.00
> >> > kpc 1987 03/05/09 60000.00
> >> >
> >> >
> >> >
> >> > Dear SIr
> >> >
> >> > Please find attached ur statement
> >> > tino 71234 15/05/09 80000.00
> >> > tino 1200 05/09/09 12000.00
> >> > tino 1288 05/07/09 67000.00
> >> >
> >> > thanks
> >> > RKS
> >> >
> >>
> >> .
> >>
>
> .
>
 
M

macropod

Flightless Bird
Hi RKS,

> pls send me another solved example so i see how i will set.
All the examples in the tutorial are 'solved'. I've even supplied a sample mailmerge main document and data source for you to
practice with. If, as your posts suggest, you don't have a good grasp of English, I suggest you seek help with that aspect from
someone who does.

You need to re-read the section titled 'Viewing The Fields' on page 1. That explains how you can see the field code for any of the
fields in the tutorial. Viewing the field codes will also show you how the 'Key' field is used.

--
Cheers
macropod
[Microsoft MVP - Word]


"RKS" <RKS@discussions.microsoft.com> wrote in message news:0046071C-01BD-4CC5-BDFE-AD1A94A150CC@microsoft.com...
>
> Hi Macropod,
>
> tutorial page are not clear and not in example. pls send me another solved
> example so i see how i will set. pls send me other solved example.
>
> Thanks
> RKS
>
>
>
> "macropod" wrote:
>
>> Hi RKS,
>>
>> The details are set out clearly on page 1 of the tutorial. The examples on the following pages show how the key field is used.
>>
>> --
>> Cheers
>> macropod
>> [Microsoft MVP - Word]
>>
>>
>> "RKS" <RKS@discussions.microsoft.com> wrote in message news:ACD3114D-CD2E-4D46-85AC-10B2B3AE0AF1@microsoft.com...
>> > Hi macropod
>> > Thanks for ur reply
>> >
>> > see ur reply in zip format but i cant get how to set key filed
>> > please clearify easy ways so i can do
>> >
>> > Thanks
>> > RKS
>> >
>> >
>> > "macropod" wrote:
>> >
>> >> Hi RKS,
>> >>
>> >> You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how,
>> >> check
>> >> out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
>> >> http://lounge.windowssecrets.com/index.php?showtopic=731107
>> >> or
>> >> http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
>> >> Do read the tutorial before trying to use the mailmerge document included with it.
>> >>
>> >>
>> >> --
>> >> Cheers
>> >> macropod
>> >> [Microsoft MVP - Word]
>> >>
>> >>
>> >> "RKS" <RKS@discussions.microsoft.com> wrote in message news:A6C83EB6-DC56-4930-A584-8A703786AEF2@microsoft.com...
>> >> > Hi
>> >> > I have large excel file like that.
>> >> >
>> >> > company invoice no date amount
>> >> > abc 1234 05/05/09 40000.00
>> >> > kpc 2534 05/05/09 30000.00
>> >> > abc 1256 05/07/09 50000.00
>> >> > kpc 1987 03/05/09 60000.00
>> >> > abc 1526 05/07/09 70000.00
>> >> > tino 71234 15/05/09 80000.00
>> >> > abc 8234 08/05/09 90000.00
>> >> > tino 1200 05/09/09 12000.00
>> >> > abc 1299 05/11/09 35000.00
>> >> > tino 1288 05/07/09 67000.00
>> >> > abc 1554 15/02/09 74000.00
>> >> >
>> >> > I m using Mail merge in office 2003 and send the letter to company his
>> >> > detail. i m using mail merge option. I get only one record to each letter
>> >> > while i wants send to letter to company thru detail like that.
>> >> >
>> >> > anyone please help me urgently. It is possible or not.
>> >> >
>> >> >
>> >> > I wants output like that....
>> >> >
>> >> > Dear SIr
>> >> >
>> >> > Please find attached ur statement
>> >> >
>> >> > abc 1234 05/05/09 40000.00
>> >> > abc 1256 05/07/09 50000.00
>> >> > abc 1526 05/07/09 70000.00
>> >> > abc 8234 08/05/09 90000.00
>> >> > abc 1299 05/11/09 35000.00
>> >> > abc 1554 15/02/09 74000.00
>> >> >
>> >> >
>> >> > Dear SIr
>> >> >
>> >> > Please find attached ur statement
>> >> >
>> >> > kpc 2534 05/05/09 30000.00
>> >> > kpc 1987 03/05/09 60000.00
>> >> >
>> >> >
>> >> >
>> >> > Dear SIr
>> >> >
>> >> > Please find attached ur statement
>> >> > tino 71234 15/05/09 80000.00
>> >> > tino 1200 05/09/09 12000.00
>> >> > tino 1288 05/07/09 67000.00
>> >> >
>> >> > thanks
>> >> > RKS
>> >> >
>> >>
>> >> .
>> >>
>>
>> .
>>
 
R

RKS

Flightless Bird
Hi macropod,

I have facing the problem for set company wise detail in one page

like that

abc
1234 05/05/09 40000.00
1256 05/07/09 50000.00
1526 05/07/09 70000.00
8234 08/05/09 90000.00
1299 05/11/09 35000.00
1554 15/02/09 74000.00

please tell me how i will set so mail merge out comes like.

i need company wise detail in single page when company name change it will
going to next page.

please tell me how i will do or send me any solved example.

thanks for ur respond
RKS



"macropod" wrote:

> Hi RKS,
>
> > pls send me another solved example so i see how i will set.
> All the examples in the tutorial are 'solved'. I've even supplied a sample mailmerge main document and data source for you to
> practice with. If, as your posts suggest, you don't have a good grasp of English, I suggest you seek help with that aspect from
> someone who does.
>
> You need to re-read the section titled 'Viewing The Fields' on page 1. That explains how you can see the field code for any of the
> fields in the tutorial. Viewing the field codes will also show you how the 'Key' field is used.
>
> --
> Cheers
> macropod
> [Microsoft MVP - Word]
>
>
> "RKS" <RKS@discussions.microsoft.com> wrote in message news:0046071C-01BD-4CC5-BDFE-AD1A94A150CC@microsoft.com...
> >
> > Hi Macropod,
> >
> > tutorial page are not clear and not in example. pls send me another solved
> > example so i see how i will set. pls send me other solved example.
> >
> > Thanks
> > RKS
> >
> >
> >
> > "macropod" wrote:
> >
> >> Hi RKS,
> >>
> >> The details are set out clearly on page 1 of the tutorial. The examples on the following pages show how the key field is used.
> >>
> >> --
> >> Cheers
> >> macropod
> >> [Microsoft MVP - Word]
> >>
> >>
> >> "RKS" <RKS@discussions.microsoft.com> wrote in message news:ACD3114D-CD2E-4D46-85AC-10B2B3AE0AF1@microsoft.com...
> >> > Hi macropod
> >> > Thanks for ur reply
> >> >
> >> > see ur reply in zip format but i cant get how to set key filed
> >> > please clearify easy ways so i can do
> >> >
> >> > Thanks
> >> > RKS
> >> >
> >> >
> >> > "macropod" wrote:
> >> >
> >> >> Hi RKS,
> >> >>
> >> >> You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how,
> >> >> check
> >> >> out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
> >> >> http://lounge.windowssecrets.com/index.php?showtopic=731107
> >> >> or
> >> >> http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
> >> >> Do read the tutorial before trying to use the mailmerge document included with it.
> >> >>
> >> >>
> >> >> --
> >> >> Cheers
> >> >> macropod
> >> >> [Microsoft MVP - Word]
> >> >>
> >> >>
> >> >> "RKS" <RKS@discussions.microsoft.com> wrote in message news:A6C83EB6-DC56-4930-A584-8A703786AEF2@microsoft.com...
> >> >> > Hi
> >> >> > I have large excel file like that.
> >> >> >
> >> >> > company invoice no date amount
> >> >> > abc 1234 05/05/09 40000.00
> >> >> > kpc 2534 05/05/09 30000.00
> >> >> > abc 1256 05/07/09 50000.00
> >> >> > kpc 1987 03/05/09 60000.00
> >> >> > abc 1526 05/07/09 70000.00
> >> >> > tino 71234 15/05/09 80000.00
> >> >> > abc 8234 08/05/09 90000.00
> >> >> > tino 1200 05/09/09 12000.00
> >> >> > abc 1299 05/11/09 35000.00
> >> >> > tino 1288 05/07/09 67000.00
> >> >> > abc 1554 15/02/09 74000.00
> >> >> >
> >> >> > I m using Mail merge in office 2003 and send the letter to company his
> >> >> > detail. i m using mail merge option. I get only one record to each letter
> >> >> > while i wants send to letter to company thru detail like that.
> >> >> >
> >> >> > anyone please help me urgently. It is possible or not.
> >> >> >
> >> >> >
> >> >> > I wants output like that....
> >> >> >
> >> >> > Dear SIr
> >> >> >
> >> >> > Please find attached ur statement
> >> >> >
> >> >> > abc 1234 05/05/09 40000.00
> >> >> > abc 1256 05/07/09 50000.00
> >> >> > abc 1526 05/07/09 70000.00
> >> >> > abc 8234 08/05/09 90000.00
> >> >> > abc 1299 05/11/09 35000.00
> >> >> > abc 1554 15/02/09 74000.00
> >> >> >
> >> >> >
> >> >> > Dear SIr
> >> >> >
> >> >> > Please find attached ur statement
> >> >> >
> >> >> > kpc 2534 05/05/09 30000.00
> >> >> > kpc 1987 03/05/09 60000.00
> >> >> >
> >> >> >
> >> >> >
> >> >> > Dear SIr
> >> >> >
> >> >> > Please find attached ur statement
> >> >> > tino 71234 15/05/09 80000.00
> >> >> > tino 1200 05/09/09 12000.00
> >> >> > tino 1288 05/07/09 67000.00
> >> >> >
> >> >> > thanks
> >> >> > RKS
> >> >> >
> >> >>
> >> >> .
> >> >>
> >>
> >> .
> >>
>
> .
>
 
M

macropod

Flightless Bird
Hi RKS,

The sample field codes under the heading 'Force Each New Category To a New Page' in the tutorial do essentially what you're asking
for.

Have you actually tried using any of these examples with the sample mailmerge main document and data source that I have provided
with the tutorial for you to practice with?

--
Cheers
macropod
[Microsoft MVP - Word]


"RKS" <RKS@discussions.microsoft.com> wrote in message news:732C1137-B660-44E7-A07B-1EB1404563F6@microsoft.com...
> Hi macropod,
>
> I have facing the problem for set company wise detail in one page
>
> like that
>
> abc
> 1234 05/05/09 40000.00
> 1256 05/07/09 50000.00
> 1526 05/07/09 70000.00
> 8234 08/05/09 90000.00
> 1299 05/11/09 35000.00
> 1554 15/02/09 74000.00
>
> please tell me how i will set so mail merge out comes like.
>
> i need company wise detail in single page when company name change it will
> going to next page.
>
> please tell me how i will do or send me any solved example.
>
> thanks for ur respond
> RKS
>
>
>
> "macropod" wrote:
>
>> Hi RKS,
>>
>> > pls send me another solved example so i see how i will set.
>> All the examples in the tutorial are 'solved'. I've even supplied a sample mailmerge main document and data source for you to
>> practice with. If, as your posts suggest, you don't have a good grasp of English, I suggest you seek help with that aspect from
>> someone who does.
>>
>> You need to re-read the section titled 'Viewing The Fields' on page 1. That explains how you can see the field code for any of
>> the
>> fields in the tutorial. Viewing the field codes will also show you how the 'Key' field is used.
>>
>> --
>> Cheers
>> macropod
>> [Microsoft MVP - Word]
>>
>>
>> "RKS" <RKS@discussions.microsoft.com> wrote in message news:0046071C-01BD-4CC5-BDFE-AD1A94A150CC@microsoft.com...
>> >
>> > Hi Macropod,
>> >
>> > tutorial page are not clear and not in example. pls send me another solved
>> > example so i see how i will set. pls send me other solved example.
>> >
>> > Thanks
>> > RKS
>> >
>> >
>> >
>> > "macropod" wrote:
>> >
>> >> Hi RKS,
>> >>
>> >> The details are set out clearly on page 1 of the tutorial. The examples on the following pages show how the key field is used.
>> >>
>> >> --
>> >> Cheers
>> >> macropod
>> >> [Microsoft MVP - Word]
>> >>
>> >>
>> >> "RKS" <RKS@discussions.microsoft.com> wrote in message news:ACD3114D-CD2E-4D46-85AC-10B2B3AE0AF1@microsoft.com...
>> >> > Hi macropod
>> >> > Thanks for ur reply
>> >> >
>> >> > see ur reply in zip format but i cant get how to set key filed
>> >> > please clearify easy ways so i can do
>> >> >
>> >> > Thanks
>> >> > RKS
>> >> >
>> >> >
>> >> > "macropod" wrote:
>> >> >
>> >> >> Hi RKS,
>> >> >>
>> >> >> You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see
>> >> >> how,
>> >> >> check
>> >> >> out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
>> >> >> http://lounge.windowssecrets.com/index.php?showtopic=731107
>> >> >> or
>> >> >> http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
>> >> >> Do read the tutorial before trying to use the mailmerge document included with it.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Cheers
>> >> >> macropod
>> >> >> [Microsoft MVP - Word]
>> >> >>
>> >> >>
>> >> >> "RKS" <RKS@discussions.microsoft.com> wrote in message news:A6C83EB6-DC56-4930-A584-8A703786AEF2@microsoft.com...
>> >> >> > Hi
>> >> >> > I have large excel file like that.
>> >> >> >
>> >> >> > company invoice no date amount
>> >> >> > abc 1234 05/05/09 40000.00
>> >> >> > kpc 2534 05/05/09 30000.00
>> >> >> > abc 1256 05/07/09 50000.00
>> >> >> > kpc 1987 03/05/09 60000.00
>> >> >> > abc 1526 05/07/09 70000.00
>> >> >> > tino 71234 15/05/09 80000.00
>> >> >> > abc 8234 08/05/09 90000.00
>> >> >> > tino 1200 05/09/09 12000.00
>> >> >> > abc 1299 05/11/09 35000.00
>> >> >> > tino 1288 05/07/09 67000.00
>> >> >> > abc 1554 15/02/09 74000.00
>> >> >> >
>> >> >> > I m using Mail merge in office 2003 and send the letter to company his
>> >> >> > detail. i m using mail merge option. I get only one record to each letter
>> >> >> > while i wants send to letter to company thru detail like that.
>> >> >> >
>> >> >> > anyone please help me urgently. It is possible or not.
>> >> >> >
>> >> >> >
>> >> >> > I wants output like that....
>> >> >> >
>> >> >> > Dear SIr
>> >> >> >
>> >> >> > Please find attached ur statement
>> >> >> >
>> >> >> > abc 1234 05/05/09 40000.00
>> >> >> > abc 1256 05/07/09 50000.00
>> >> >> > abc 1526 05/07/09 70000.00
>> >> >> > abc 8234 08/05/09 90000.00
>> >> >> > abc 1299 05/11/09 35000.00
>> >> >> > abc 1554 15/02/09 74000.00
>> >> >> >
>> >> >> >
>> >> >> > Dear SIr
>> >> >> >
>> >> >> > Please find attached ur statement
>> >> >> >
>> >> >> > kpc 2534 05/05/09 30000.00
>> >> >> > kpc 1987 03/05/09 60000.00
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > Dear SIr
>> >> >> >
>> >> >> > Please find attached ur statement
>> >> >> > tino 71234 15/05/09 80000.00
>> >> >> > tino 1200 05/09/09 12000.00
>> >> >> > tino 1288 05/07/09 67000.00
>> >> >> >
>> >> >> > thanks
>> >> >> > RKS
>> >> >> >
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >> .
>> >>
>>
>> .
>>
 
You must log in or register to reply here.
Top