Is It Possible to Merge MS Word Document with Two Online Data Sources??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Moose - 22 Aug 2006 00:58 GMT

Is It Possible to Merge MS Word Document with Two Online Data Sources??

* The MS Word document is located on my harddrive.
* One XLS file is located on the internet on a site that I have access
to.
* One TXT file is located on the internet on a site that I have access
to.

The XLS file contains pricing information, SKU number, product title.
The TXT file contains SKU number and product description.

Is it possible to merge all three of these documents together using MS
Word mail-merge??

I could download the XLS file and the TXT file, but, these two files
change periodically -- which means that I'd always have to download a
current copy before I perform the mail merge. Additionally, I'm not
sure if one can use TWO data sources. Again, I could pull the TXT into
the XLS if I download -- before every mail-merge.

Thanks.

Barb

Reply to this Message

Doug Robbins - Word MVP - 22 Aug 2006 04:24 GMT

No, it is not possible. Mailmerge can only work with a single, flat data
source. You will need to download and combine the two data sources,
updating the combined file whenever one of the source files changes.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is It Possible to Merge MS Word Document with Two Online Data Sources??
>
[quoted text clipped - 19 lines]
>
> Barb

Reply to this Message

The Moose - 23 Aug 2006 13:19 GMT

Thanks. I figured that was probably a limitation of the software.
Have to figure out some other way of doing thanks.

Appreciate your input.

Barb

> No, it is not possible. Mailmerge can only work with a single, flat data
> source. You will need to download and combine the two data sources,
[quoted text clipped - 31 lines]
> >
> > Barb

Reply to this Message