Mailing: Reading values from Excel to Word

OTPM · #1 09-01-2011, 05:30 AM

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)

Jamal NUMAN · #2 09-01-2011, 07:28 AM

Quote:

Originally Posted by OTPM

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

Catalin.B · #3 09-02-2011, 01:45 AM

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...

Jamal NUMAN · #4 09-02-2011, 02:08 AM

Quote:

Originally Posted by Catalin.B

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why the "day" is not inserted as we read values from Excel to Word?	Jamal NUMAN	Word	8	09-04-2011 07:48 AM
Reading Values from another sheet	Raabi	Excel	2	05-20-2011 02:14 AM
Outlook/excel mass mailing of greeting card	marbetu	Outlook	0	12-22-2010 02:55 AM
Creating mailing labels from list in excel	wordnoob2	Mail Merge	0	12-13-2010 03:46 PM
Word - Calculate and paste values from Excel sheet	Augf87	Word	1	07-06-2009 10:26 AM