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: 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 It might help you to solve your problem.
May 21st, 2012 11:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics