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
Free Windows Admin Tool Kit Click here and download it now
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