vineri, martie 23, 2007

Mad Libs with SharePoint and Word

My friend Yatin Purohit said:

An easy way is to link a SharePoint Services List (say, contacts) to Access 2003 then use Access as a data source in Word 2003 for mail merge.

In Access 2003, create a new blank database (.mdb). Then in menu File -> Get External Data -> Link Tables. In the dialog box, select "Type of Files" as Windows SharePoint Services(). In the wizard that follows, Type site name and then the List name, plus other option for whole list or a view. You will see the linked table in Access where you can also make chages, queries, etc.

In Word 2003 create the base document, then select menu Tools -> Letters and Mailing -> MailMerge. Use the task pane for mail merge. Open the Mail Merge tool bar and in Data Sources dialog box, select File Type as Access and the new .mdb file. Now you are set to add fields from the list to the mailmerge document.

Niciun comentariu:

Despre mine

Timi-Ostravia, Republic of Czedvia, Bulgaria
I make web applications. The tools I use are many and far between. I have been maining to learn Ruby and Python, and Perl. These tools are all like Lego to me. They can all be make to build things and have their strengths and weakest.