Not getting the column titles while male merge

Dear friends,
I have created a database of coupans collection and I want to send the letters to all using male merge function. I tried it but I am not getting column titles in insert male merge step. I want the following column titles in a list of table headings after clicking 'insert mail merge fields' option. My fields are as follows:

SR. NO. INWARD NO. INWARD DATE DISTRICT TALUKA SENDER MOBILE PHONE OFFICE ADDRESS "MODE OF
PAYMENT" CHEQUE/DD NO. "Cheque/dd/
CASH date" "NAME OF
BANK" RECEIPT NO. "RECEIPT
DATE" AMOUNT "AMOUNT
( IN WORDS)" MONTH OUTWARD NO. "OUTWARD
DATE" DISTRICT "TALUKA
Ahmednagar-Bhandara" "TALUKA
Buldhana-Hingoli" "TALUKA
Jalgaon-Nagpur" "TALUKA
Nanded-Pune" "TALUKA
Raigad-Solapur" "TALUKA
Thane-Yavatmal" MONTH ABBREVIATION



All these fields should be there for selection. I will select the fields as per my requirement.
Sample file is attached.

Mukesh

If your data in excel was not flatten base or table, Mail Merge will not get the title on your excel it automatically assign F1, F2, F3...., if you want to automatically get the title heading of your excel in Mail merge you need to convert your excel data to Excel Table and should start in A1 otherwise you need to remember the column, in your case you have in your mail merge title "ABC FOUNDATION", then " "FLAG DAY COUPANS COLLECTION MASTER DRAFT" and for B4[SR. No.] = F1, C4[INWARD No.] = F2 etc)

Hello acerrhod,
Thank you for your response. Sorry I didn't understand flatten base or table. I can't start the table from a1 because the name of institute should be there on the top of the table. So in this case you suggested me to remember assigned to column title as b4 sr no f1 and so on.
Please guide it more in detail for my better understanding. I have attached a sample thanks letter here which I have to send to all the donners. In this letter I want to include only following column titles.
outward no.
outward date
sender
address
receipt no.
receipt date

Please assign these column titles to f1, f2, f3 etc. and insert it in this sample thanks letter for output of thanks letter.
Please explain me how to assign this column titles to f1, f2, f3, etc. respectively.
How to create a table flatten base?
Thanking you in anticipation.

Mukesh

Hello acerrhod,
Thank you for your response. Sorry I didn't understand flatten base or table. I can't start the table from a1 because the name of institute should be there on the top of the table. So in this case you suggested me to remember assigned to column title as b4 sr no f1 and so on.
Please guide it more in detail for my better understanding. I have attached a sample thanks letter here which I have to send to all the donners. In this letter I want to include only following column titles.
outward no.
outward date
sender
address
receipt no.
receipt date

Please assign these column titles to f1, f2, f3 etc. and insert it in this sample thanks letter for output of thanks letter.
Please explain me how to assign this column titles to f1, f2, f3, etc. respectively.
How to create a table flatten base?
Thanking you in anticipation.

Mukesh

Hello macropod,
Thank you but how to set the name range from row 4 because the name of institute should be there.
Please guide me in detail for my better understanding.
Thanking you in anticipation.

Mukesh

F1, F2, F3 and so on are assign by the MAIL MERGE when you create the link (your excel File), you just memorized those F1, F2, F3 and so on the column title that the mail merge assign to it, in the mail merge wizard at the mail merge recipient) something like this:
Date Source F1 F2 F3..
your excel file S.R. No. INWARDS No. INWARDS Date...

Hello,
I know the naming function which I have used in my table. Please see it. Secondly the name of institute means that 'abc foundation' should be there in the table but not in mail merge thanks letter.
I have mentioned that I want to merge only few column titles mentioned in my previous reply.
outward no.
outward date
sender
address
receipt no.
receipt date

Only above mention column titles should be there in a mail merge thanks letter attached in last reply.
Now please guide me how to do this by using naming function. Just give me a idea I will do it.
Waiting to get a solution eagerly.
Thanking you in anticipation.

Mukesh

Check the attachment

Dear macropod,
Thank you. Please tell me how to use naming function in mail merge. Do you mean that I should create a name range 'b4:ad5004' and name it as 'mailmerge'? Please guide me how will I get the column titles in mail merge insert step.
Sorry for trouble.
Thanking you in anticipation.

Mukesh
y

Dear friend,
Sorry! I'm not understanding your suggestion in short. Please do spend some time and take trouble to adjust it in my attached files. Please send me adjusted files so that I can understand your suggestion more correctly.
Please do it for me because since last week I'm trying but in vain and I have to complete it at the earliest. It's already late for me.
Waiting to receive adjusted files soon.
Thanking you in anticipation.

Mukesh

Dear friend,
You are absolutely right but due to my understanding problem I requested you to do it for me to accomplish my task in time. I will observe the file and go through it and will see how you have created mailmerge naming and other functions.
Finally, I humbly request you to do it for me I will be greatful to you. I will learn it by observing the file in detail. You are requested to give me some step by step instructions to accomplish this difficult task.
Sorry for trouble once again. Sorry! Sorry! Sorry!

Thanking you in anticipation.

Mukesh

Dear acerrhod,
I followed your instructions but unable to complete mailmerge successfully. I get the error message as follows:

Word cannot complete the save due to file permission error.
(C:\users\Mukesh\App data\...\~WRD0000 tmp)

Please help me.
Thanking you in anticipation.

Mukesh

Hmmm there seems to be some confusion here maimerge is very easy to use, but I'm a little confused as to what you want? Why do you not just put the relevant fields in an Excel file that you wish to merge? Surely that will make it easier for whoever is using it? then you wont have to worry about f1 etc you can start from A1?

You may want to change your title thread to Mail rather than male

Hi, not sure where you are with this? take a look at the Excel file MAILMEGE, then look at the WORD DOC, (ABC SOLUTIONS) this has your title so no need to have that in the Excel file, this may make it easier for you, any questions go ahead.

Very good morning Hurricanefly,
Thank you for guidance. It's working fine. I request you to send me a step by step guidance of mail merge so that I will not make such a silly mistakes in future. To avoide the traffic on forum you may send the step by step guidance file on my personal email id as follows:

mukeshbaviskar.nsk@gmail.com

I like your idea of starting the excel data from a1 to avoide confusion.
Sorry for spelling mistake which gives the totally different meaning. This is a magic of English language. I didn't find the option to correct my thread title.
I don't want to do the insert merge fields step each time that means I want to do it in the beginning first time only. Then second time I want to start the mail merge from the finish mail merge step the final step only to avoide time and mistake in future.
Which is the correct option after clicking word file yes/no. that is this will run the following sql command on your computer, yes/no.

Waiting to receive step by step guidance of mail merge today positively. Sorry for trouble.
Thanking you in anticipation.

Mukesh

What part are you having problems with?

1) Enter your data in the Excel file
2) Close the Excel file
3) Open the Word document
4)Select Mailings tab
5)Start Mail Merge (Letters)
6)Select Recipients(use existing list) FIND YOUR EXCEL FILE
7)Insert Merge fields
8)Finish & merge
9)Now you will have as many letters that is in your excel database.

Dear Hurricanefly,
Thank you for steps of mail merge. I also follow these steps but I get error message after finish mail merge . Now I click on that error message and then I get the letters with merge fields in it.
Thank you for guidance.

Mukesh

What does your error message say? and you have marked your thread as solved?

I have attached the files again updated with instructions on the word document.