sudeep
New Member
- Joined
- Nov 28, 2006
- Messages
- 39
Hi.
I am trying mail merge my data file in excel with word. I want the word doc. to have all un-repeated portions of the data. Basically, I need to send letters to all my customers giving a statement of their account containing their cheque details and demands raised by us.
A snap shot of my data file is as under:
Apt. No. Name of the Owner Address Contact No Source Debit Amt Credit Amt Cheque No. Date Bank Name
T-0101 Raja Ram 123, Rajabahadur 123 Cheque 1221 12123324 1-Jan-11 ICICI Bank
T-0102 Suresh Kumar Minnat Nagar 4354 Cheque 32321 43535 1-Feb-11 State Bank of Indore
T-0103 Rajesh Singh Qutub Minar 55647 Cheque 42343 345654 7-May-11 SBI
T-0104 Raja Ram 123, Rajabahadur 45767657 Cheque 4543 676576 3-Nov-11 HDFC
T-0101 Raja Ram 123, Rajabahadur 123 Demand 23234 25-Dec-10
T-0102 Suresh Kumar Minnat Nagar 4354 Demand 434254 16-Mar-11
T-0105
T-0106
T-0107 Prakash Singh Honolulu 5344 Cheque 23432 6577867 12-Mar-11 People's Co-op. Bank
T-0107 Prakash Singh Honolulu 45444345 Cheque 32423 87687776 11-May-11 People's Co-op. Bank
T-0108
In the above file Apt. Nos. are input. Col. B, C and D are vlookup entries and all further columns are inputted manually.
Output expected as under for Apt. No. T-0101 in mailmerge word document
Date
Raja Ram
123, Rajabahadur.
Sub: Your statement of Account: Flat No. {Flat No.}
Sir,
We are giving below your statement of account in respect of above mentioned flat.
Date Source Cheque No. Date Bank Debit Amount Credit Amount
{25-Dec-10} {Demand} {23234.00}
{1-Jan-11} {Cheque} {12123324} {1-Jan-11}{ICICI Bank} {1221.00}
[13-Mar-11] [Receivable] [22013.00]
{} Denotes automatically inserted values / text from excel Data file
[] These values are input by the system and calculated.
Please note there is no limit to the number of entries that are imported by word and mail merge seeks the entries based on flat nos.
I would require a very flexible system that I can use for other kinds of mail merge functions too.
Thankyou so much in advance.
Sudeep
NB: I am not a qualified user of excel but with lots of passion. Please bear my further questions.
I am trying mail merge my data file in excel with word. I want the word doc. to have all un-repeated portions of the data. Basically, I need to send letters to all my customers giving a statement of their account containing their cheque details and demands raised by us.
A snap shot of my data file is as under:
Apt. No. Name of the Owner Address Contact No Source Debit Amt Credit Amt Cheque No. Date Bank Name
T-0101 Raja Ram 123, Rajabahadur 123 Cheque 1221 12123324 1-Jan-11 ICICI Bank
T-0102 Suresh Kumar Minnat Nagar 4354 Cheque 32321 43535 1-Feb-11 State Bank of Indore
T-0103 Rajesh Singh Qutub Minar 55647 Cheque 42343 345654 7-May-11 SBI
T-0104 Raja Ram 123, Rajabahadur 45767657 Cheque 4543 676576 3-Nov-11 HDFC
T-0101 Raja Ram 123, Rajabahadur 123 Demand 23234 25-Dec-10
T-0102 Suresh Kumar Minnat Nagar 4354 Demand 434254 16-Mar-11
T-0105
T-0106
T-0107 Prakash Singh Honolulu 5344 Cheque 23432 6577867 12-Mar-11 People's Co-op. Bank
T-0107 Prakash Singh Honolulu 45444345 Cheque 32423 87687776 11-May-11 People's Co-op. Bank
T-0108
In the above file Apt. Nos. are input. Col. B, C and D are vlookup entries and all further columns are inputted manually.
Output expected as under for Apt. No. T-0101 in mailmerge word document
Date
Raja Ram
123, Rajabahadur.
Sub: Your statement of Account: Flat No. {Flat No.}
Sir,
We are giving below your statement of account in respect of above mentioned flat.
Date Source Cheque No. Date Bank Debit Amount Credit Amount
{25-Dec-10} {Demand} {23234.00}
{1-Jan-11} {Cheque} {12123324} {1-Jan-11}{ICICI Bank} {1221.00}
[13-Mar-11] [Receivable] [22013.00]
{} Denotes automatically inserted values / text from excel Data file
[] These values are input by the system and calculated.
Please note there is no limit to the number of entries that are imported by word and mail merge seeks the entries based on flat nos.
I would require a very flexible system that I can use for other kinds of mail merge functions too.
Thankyou so much in advance.
Sudeep
NB: I am not a qualified user of excel but with lots of passion. Please bear my further questions.
