Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2005

Tip: Looking for answers? Try searching our database.

MailMerge Data Sources

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill S. - 08 Jan 2005 02:38 GMT
Hi,

I'm sure if this is the right newsgroup, but I'm hoping I can get some info
about MSWord MailMerge data sources. I'm driving Word through the COM
interface in my VB.NET program, and I've create a table in my DataSet. I'm
trying to use this table as a data source for a MailMerge. Is this possible?
I can't seem to get the OpenDataSource() sub to work.

What data sources are possible?
Are there any Web sites with example VBA/VB.NET/VB6 code?

Any help would be greatly appreciated.
Peter Jamieson - 08 Jan 2005 10:07 GMT
Word can use a number of different types of data source, but they are all
either "file data sources", e.g. a .csv file, excel file, access .mdb, or
oledb/odbc data sources.

To use a "disconnected recordset" of any kind, you would have either to be
able to access it via an existing OLEDB provider/ODBC driver (I know of no
way to do this) or write your own OLEDB provider/ODBC driver (or, just
possibly, text converter) to do the job, and I'm not sure even that is
feasible unless you are able to pass a usable reference to the recordset you
want to use.

If you commit your dataset to (say) a SQLServer database, you should be able
to use an OLEDB or ODBC connection in OpenDataSource, but for OLEDB you will
need an external .odc file and for ODBC you will need an external DSN
(either "machine", or "file"). For OLEDB you may be able to create an empty
.odc file and provide all the necessary connection info. in the Connection
parameter of the OpenDataSource method.

Peter Jamieson

> Hi,
>
[quoted text clipped - 8 lines]
>
> Any help would be greatly appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.