Mailing: Reading values from Excel to Word

please, see the attached image that shows my question


i need to write values from Excel to Word. the problem that the values that exist in row 2 in Excel is printed in page 1 in Word which is quite misleading!!!!!

how to uncounte the heading of row number 1 in Excel?

i need the numbers in Excel and Word to be udentical such that the values of row number 2 in Excel are printed in page number 2 in Word

how can i do that?

regards



Jamal

Attached Images

Clip_921.jpg (84.7 KB, 16 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

Hi
If I understand you correctly all you would need to do is put a title page in your Word document, then the entry from Row 2 of your spreadsheet would be in page two of your document.
Hope this helps.
Tony(OTPM)

in a mail merge, The name of each data field is listed in the first row (header row) of the data source, so that the first entry in the data base is on row 2, and will be placed on first page of the merged document, this cannot be changed...(header row cannot be removed, otherwise mail merge will not work)

Thank you for the answer Tony and Catalin,

such behavior in Word is quite misleading! that the data in row number 2 refers to page 2 in word (example)!!!

- the idea of Tony is good as work around! but still will affect the main Word document

- the second idea is to add another column to the excel file to make the data in the row number are identical to the number of page in word!

- I'm wondering why "unchecking" the "first row of data contains column heading" doesn't affect the Word behavior! such that row number 1 refers to page number one!!!! (ATTACHED)

regards

Jamal

Attached Images

Clip_944.jpg (88.9 KB, 12 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

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

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

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, 10 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

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

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.