Remove mailmerge data source via OpenXML

Posted by Dan on Stack Overflow See other posts from Stack Overflow or by Dan
Published on 2010-03-23T17:22:01Z Indexed on 2010/03/23 18:53 UTC
Read the original article Hit count: 559

Filed under:

openxml

|

mailmerge

I have some code that uses OpenXML to open up a docx file, find all mailmerge fields, and replace them with data (ignoring the datasource that may have been provided).

I initially tested this against a document created in Office 2007 and it seemed to work great.

We then created one in 2003 based off an Excel spreadsheet data source and saved it to 2007 docx format. When we open the file produced by my code, Word warns the user that it is going to execute some SQL, specifically "SELECT * from 'Sheet1$'". It has options of Yes/No. Selecting Yes requires I find the data source. Selecting No brings me to the document, which appears to be correct.

I'm not sure why I'm now seeing this pop up. Perhaps it's due to a different data source for the 2003 document?

My hope was that there was a way to delete all references to any datasources and that the pop-up wouldn't show. I found this, but it doesn't seem to work. Any suggestions?

© Stack Overflow or respective owner

Related posts about openxml

Convert OpenXml Excel files to HTML

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. I'm developing printing solution for MS Office 2007, office automation is not good for me, because it requires installed office. Open XML Document Viewer is solution for converting Word files (.docx) to HTML format by XSLT transform, but it works only for .docx. Can you suppose related or similar… >>> More
Remove mailmerge data source via OpenXML

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some code that uses OpenXML to open up a docx file, find all mailmerge fields, and replace them with data (ignoring the datasource that may have been provided). I initially tested this against a document created in Office 2007 and it seemed to work great. We then created one in 2003 based… >>> More
Can someone explain how OpenXML works(in this SP)?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am looking at this tutorial and it confuses me as I don't get the SP CREATE PROCEDURE [dbo].[spTEST_InsertXMLTEST_TEST](@UpdatedProdData nText) AS DECLARE @hDoc int exec sp_xml_preparedocument @hDoc OUTPUT,@UpdatedProdData INSERT INTO TBL_TEST_TEST(NAME) SELECT XMLProdTable.NAME … >>> More
Retrieve the content of Microsoft Word document using OpenXml and C#

as seen on YBBest - Search for 'YBBest'
One of the tasks involves me to retrieve the contents of Microsoft Word document (word2007 above). I try to search for some resources online with not much luck; most of the examples are for writing contents to word document using OpenXml. I decide to blog this as my reference and hopefully people… >>> More
OpenXML SDK: Make Excel recalculate formula

as seen on Stack Overflow - Search for 'Stack Overflow'
I update some cells of an Excel spreadsheet through the Microsoft Office OpenXML SDK 2.0. Changing the values makes all cells containing formula that depend on the changed cells invalid. However, due to the cached values Excel does not recalculate the formular, even if the user clicks on "Calculate… >>> More

Related posts about mailmerge

Switch Text Paragraphs in OpenOfficeOrg Writer mailmerge

as seen on Super User - Search for 'Super User'
I am using mailmerge to write the same letter with minor differenes to many peolpe. I experienced that switching text paragraphs depending on database values was not easy for me. I ended up putting huge text paragraphs into the database becaus switching did not really work for me. Actually I dont'… >>> More
Remove mailmerge data source via OpenXML

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some code that uses OpenXML to open up a docx file, find all mailmerge fields, and replace them with data (ignoring the datasource that may have been provided). I initially tested this against a document created in Office 2007 and it seemed to work great. We then created one in 2003 based… >>> More
Hide the attachment list on the top of the Hotmail mailmerge

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am just starting to use Microsoft Word or Publisher to sent a Email Newsletter Mailshot to my clients, The attachment list of the photos i have used at the top of the Email does not look good. Is there any way i can use photo's without showing the attachment list on top, or hide the list… >>> More
Referring to mailmerge fields in an if statement

as seen on Super User - Search for 'Super User'
Context: Windows 7 Microsoft Office Word 2007 I have a mailmerge field named "On_FB". Current code: { IF { On_FB } = "Y" "You're on Facebook." "You're not on Facebok."} The moment I get out of code-editing view, the code goes haywire. When I flip back to code-editing view, I see that the code… >>> More
MS Word: Mailmerge hyperlinks with query get url string with a mergefield.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to send an email merging one document (docx) with a contacts database (via OleDB). Using MSWord2007, it seems easy (it works for easy things: name, address, ...) but I can't find how fill an query-get url string with a merge field inside an hyperlink. An hyperlink like: Click here… >>> More