Hi


As Catalin advises this is the normal behavious of Mail Merge where the first row of the source data ALWAYS contains the feild names. The only other way to achieve what you are looking for is NOT to have any headers in your source data and use the column indicators (A,B,C etc....) as your source column headers. That way your numbers would be in sync between Word and Excel.
Hope this helps.
Tony(OTPM)

thank you for the answer OTPM.

But is there away to replace the A, B, C with words? and how come to have columns with no headers?

regards

Jamal

Hi Jamal
A user cannot change the default column headers in Excel to their own requirements.
The reason I am suggesting you have no data column headers is so that the record number in excel will correspond to the page number in Word that you are after.
Hope this helps.
Tony(OTPM)

Thanx Tony.

I do understand your suggestion. but it is impossible to have columns with no headers! A column with no header doesn't make any sense!

I think adding another column for the numbers in the excel file is a good suggestion! (Attached)

regards

Jamal

Attached Images

Clip_949.jpg (94.5 KB, 12 views)

Well, Jamal, it is up to you to decide if it makes sense or not... and to choose the best solution that fits you..
Personnaly, i don't care if the database i create for a specific mail merge has header row or not... what it matters for me it's the result in the merged document that's what i'm after, i can delete that database after creating the mail merge...

Anyway, this thread is meant for Word Threads, not to Excel threads, your database is not excel only, there are a lot of database types... For mail merging, you can use even a word document with a single table in it containing your data. Just decide when connecting to database, to check or uncheck the option: my database has header row...

Thank you Catalin. I appreciate your notes and help.

regards

Jamal