Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Søren Dalhoff Søren Dalhoff is offline
external usenet poster
 
Posts: 6
Default Word merge using sharepoint lists directly?

Is it possible to merge word directly using sharepoint data list, without
exporting the sharepoint data into excel and then merging with excel?

Microsoft Windows Small Business Server 2003, Premium Edition
Office 2003

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Word merge using sharepoint lists directly?

If you are still interested in this, I believe it is possible to merge from
a Sharepoint list using a linked table in Access, but it's tricky to set up.

However, to do that, you need Access on your system and you need to link to
the relevant Sharepoint list(s). Also, you will probably find that Word does
not "see" the linked tables when you try to link to the Access database, but
I believe it will correctly use them if you issue the correct SQL in a VBA
OpenDataSource command.

I believe it should be possible to create an Access .mdb and the appropriate
linked tables programmatically using ADOX (even if you haven't got Access on
your system) but even that is tricky because
a. you need to find out the "internal" name of the Sharepoint list in order
to create the linked table. There are apparently ways to do that
programmatically but I haven't explored them yet. The simplest way is to use
Access to create the link and examine the resulting table's properties, but
of course that means you have to have Access (although you could probably
distribute the resulting .mdb to non-Access systems)
b. The correct VBA to do this still eludes me

Peter Jamieson

"Sren Dalhoff" wrote in message
...
Is it possible to merge word directly using sharepoint data list, without
exporting the sharepoint data into excel and then merging with excel?

Microsoft Windows Small Business Server 2003, Premium Edition
Office 2003



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Søren Dalhoff Søren Dalhoff is offline
external usenet poster
 
Posts: 6
Default Word merge using sharepoint lists directly?

Not sure why I should use Access because the sharepoint is running on SQL.
Do you have any link or doc on how to setup?

Søren Dalhoff

"Peter Jamieson" wrote:

If you are still interested in this, I believe it is possible to merge from
a Sharepoint list using a linked table in Access, but it's tricky to set up.

However, to do that, you need Access on your system and you need to link to
the relevant Sharepoint list(s). Also, you will probably find that Word does
not "see" the linked tables when you try to link to the Access database, but
I believe it will correctly use them if you issue the correct SQL in a VBA
OpenDataSource command.

I believe it should be possible to create an Access .mdb and the appropriate
linked tables programmatically using ADOX (even if you haven't got Access on
your system) but even that is tricky because
a. you need to find out the "internal" name of the Sharepoint list in order
to create the linked table. There are apparently ways to do that
programmatically but I haven't explored them yet. The simplest way is to use
Access to create the link and examine the resulting table's properties, but
of course that means you have to have Access (although you could probably
distribute the resulting .mdb to non-Access systems)
b. The correct VBA to do this still eludes me

Peter Jamieson

"Søren Dalhoff" wrote in message
...
Is it possible to merge word directly using sharepoint data list, without
exporting the sharepoint data into excel and then merging with excel?

Microsoft Windows Small Business Server 2003, Premium Edition
Office 2003




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Word merge using sharepoint lists directly?

Not sure why I should use Access because the sharepoint is running on SQL.

Have you tried linking directly to the SQL Server database with the
Sharepont info. using either ODBC or (probably better) OLEDB? I managed to
do that here a while back, but as far as I can remember the default
permissions for the relevant SQL Server database do not allow it so you
might have to alter them (and maybe you cannot do that).

The reason for suggesting Access is simply that it's easier to do it and I
know it is feasible. In fact, it's slightly easier than I thought. The
procedure is as follows:
a. create a new blank database
b. navigate to File|get External Data|Link tables
c. In the "Files of type" listbox, select Windows Sharepoint Services ()
d. Enter the site address and take it from there. There is an option to
link to more than one table so that lookup items are also available in
Access.
e. If you try using these linked tables as data sources in Word, I don't
think Word will "see" them, but if you create a query in Access that gets
all the items for a linked table, Word seems to "see" that and you should be
able to use it as a data source.

Peter Jamieson

"Sren Dalhoff" wrote in message
...
Not sure why I should use Access because the sharepoint is running on SQL.
Do you have any link or doc on how to setup?

Sren Dalhoff

"Peter Jamieson" wrote:

If you are still interested in this, I believe it is possible to merge
from
a Sharepoint list using a linked table in Access, but it's tricky to set
up.

However, to do that, you need Access on your system and you need to link
to
the relevant Sharepoint list(s). Also, you will probably find that Word
does
not "see" the linked tables when you try to link to the Access database,
but
I believe it will correctly use them if you issue the correct SQL in a
VBA
OpenDataSource command.

I believe it should be possible to create an Access .mdb and the
appropriate
linked tables programmatically using ADOX (even if you haven't got Access
on
your system) but even that is tricky because
a. you need to find out the "internal" name of the Sharepoint list in
order
to create the linked table. There are apparently ways to do that
programmatically but I haven't explored them yet. The simplest way is to
use
Access to create the link and examine the resulting table's properties,
but
of course that means you have to have Access (although you could probably
distribute the resulting .mdb to non-Access systems)
b. The correct VBA to do this still eludes me

Peter Jamieson

"Sren Dalhoff" wrote in message
...
Is it possible to merge word directly using sharepoint data list,
without
exporting the sharepoint data into excel and then merging with excel?

Microsoft Windows Small Business Server 2003, Premium Edition
Office 2003






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Word merge using sharepoint lists directly?

b. The correct VBA to do this still eludes me

Not any more...

Peter Jamieson

"Peter Jamieson" wrote in message
...
If you are still interested in this, I believe it is possible to merge
from a Sharepoint list using a linked table in Access, but it's tricky to
set up.

However, to do that, you need Access on your system and you need to link
to the relevant Sharepoint list(s). Also, you will probably find that Word
does not "see" the linked tables when you try to link to the Access
database, but I believe it will correctly use them if you issue the
correct SQL in a VBA OpenDataSource command.

I believe it should be possible to create an Access .mdb and the
appropriate linked tables programmatically using ADOX (even if you haven't
got Access on your system) but even that is tricky because
a. you need to find out the "internal" name of the Sharepoint list in
order to create the linked table. There are apparently ways to do that
programmatically but I haven't explored them yet. The simplest way is to
use Access to create the link and examine the resulting table's
properties, but of course that means you have to have Access (although you
could probably distribute the resulting .mdb to non-Access systems)
b. The correct VBA to do this still eludes me

Peter Jamieson

"Sren Dalhoff" wrote in message
...
Is it possible to merge word directly using sharepoint data list, without
exporting the sharepoint data into excel and then merging with excel?

Microsoft Windows Small Business Server 2003, Premium Edition
Office 2003





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Converting WordPerfect 12 files to Word 2003 Curious New Users 4 May 19th 23 02:48 PM
Why dont MS just f**king re-write Word from scratch? Its dogsh*t Word Hater Microsoft Word Help 33 May 5th 23 02:52 PM
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Detach or change SQL data source for Word template, and other Qs SJMac Mailmerge 6 July 27th 06 10:12 AM


All times are GMT +1. The time now is 01:51 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"