Mail merge summarise

R

RKS

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

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 said:
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 said:
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

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 said:
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 said:
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 said:
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

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 said:
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 said:
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 said:
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]


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

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 said:
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 said:
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 said:
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


:

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]


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

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 said:
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 said:
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 said:
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]


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


:

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]


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

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 said:
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 said:
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 said:
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



:

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]


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


:

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]


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


.


.

.
 
Top