Mail merge with sharepoint list as datasource
I have a huge list set up in sharepoint. I want to use the fields in this list to merge into a word document. Now, I am using Excel as the source for the mail merge in Word. I use the data connection in Excel to show the data, then use the fields for my merge in word. I want to cut Excel out of the picture, download the data fields directly to word. I can't seem to get word to connect to Sharepoint like I can Excel. Is this possible? Please don't respond with a whole bunch of code, as I'm not a coder, I'm a regular person trying to use the tools. There has to be a way to do this so that you don't have to have a techno-geek.
June 7th, 2011 12:36pm
Hi , I understand that you want to connect the SharePoint list item to word directly .It is a tough job without writing any codes .You can only achieve this with Excel or Access to be the intermediary . If you want to use some script to realize this ,please refer to these sites: source code for exporting sharepoint list items to word: http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/8aa3fa6d-2078-4bf7-ad9d-1ff5e689ecce Export SPGridView to Excel spreadsheet in Sharepoint 2007: http://www.fivenumber.com/export-spgridview-to-excel-spreadsheet-in-sharepoint-2007/ Thanks ,Regards, Rock Wang Microsoft Online Community Support
June 8th, 2011 6:39am
Hi There Pam, You could try this out www.dcsoftwaresolutions.com/default.aspx It might help you to solve your problem.
May 21st, 2012 11:43pm