Using data sources from Excel in Word

Help_me · Mar 4th 2003

Im trying to use multiple data sources in a Word mail merge letter that are taken from tables in an Excel workbook.
I've already set up one data source from a table in one of Excel worksheets. This has address details for my letter in word.
Now i want to set up a different data source to be used in the same letter. The data needs to come from the same Excel worbook but from a different worksheet.
This is causing porblems because Word doesn't recognize TWO data sources being used in the same document and it cancels out the older data source.

Is there any way around this???

or do i have to change my Excel workbook so that all the data i want to use comes from one single table.

Any ideas? thanks

**Jack in the UK** · Mar 4th 2003

Ermm

I’ve always found one data source is best, little help bar a reference call

Hope some assistance

Jack in the UK

BTW this is a failing in Word a composite version on VBA Excel will not suffer, but this utilty of Jacks is very proto type just now, soon as ill post it for all.

BUT Down side is I can merger 1700 documents in 30 seconds where my utility will only do 18 a minute >>>>>> Arggggg!!!

XL-Dennis · Mar 4th 2003

Hi Help_me,

It could be achieved by using VBA however it out some demand on You.

So if You not familiar with VBA perhaps You should go with JIUK's advice about one source.

Help_me · Mar 6th 2003

Thanks for the help ladz!
I think'll i stick to just using one data source. Less hassle you see.

:cheers:

Using data sources from Excel in Word

Participate now!

Share