{"id":312,"date":"2008-10-03T10:52:58","date_gmt":"2008-10-03T10:52:58","guid":{"rendered":"http:\/\/parkesy.wordpress.com\/2008\/10\/03\/opening-excel-during-a-mail-merge\/"},"modified":"2008-10-03T10:52:58","modified_gmt":"2008-10-03T10:52:58","slug":"opening-excel-during-a-mail-merge","status":"publish","type":"post","link":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/","title":{"rendered":"Opening Excel During a Mail Merge"},"content":{"rendered":"

It\u2019s weird how people panic when something is slightly different to how they expect<\/p>\n

I client called me this morning as she was trying to do a mail merge but it was behaving differently to how her other mail merges work<\/p>\n

Basically when she opened the Word document with the mail merge in, Excel also opened at the same time. She was able to view the data and make any changes she needed while doing the merge<\/p>\n

This didn\u2019t happen with the other merge<\/p>\n

I was initially a bit boggled by this but then noticed as Word was opening the Excel file the status bar indicated it was trying to send DDE messages<\/p>\n

DDE is an old technology<\/a> that allow Windows programs to share data. Previous versions of Word used to DDE as part of the mail merge process. <\/p>\n

The default method for Word 2003 (which is what she was using) is to use OLEDB<\/a>, allowing Word to \u201ctalk\u201d directly to the Excel file<\/p>\n

You can change this behaviour though<\/p>\n

Click on the \u201ctools\u201d menu and select \u201coptions\u201d. Then click the \u201cGeneral\u201d tab and put a tick in the \u201cConfirm conversion at option\u201d box. When you create a new mail merge and point to an Excel file it ask you how you want to talk to it and are able to select DDE<\/p>\n

I later found out the original mail merge was set up many years ago and the problem she having was with a brand new merge, which is why she\u2019d not seen this before<\/p>\n

She could have done her merge using OLEDB but she was in such a panic as the file hadn\u2019t opened that she thought there was a problem<\/p>\n

The mail merge actually works fine using both methods but because it wasn\u2019t working as expected she thought there was a problem<\/p>\n

Also as a side note\u2026as well as spotting the DDE commands I also noticed a difference in the warning message when opening the Word document<\/p>\n

When you open a Word document (as of XP SP3) that talks to external data you get a warning message<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n

\n

Opening this document will run the following SQL command:
SELECT * FROM your datasource<\/var>
Data from your database will be placed in the document. Do you want to continue?<\/p>\n<\/blockquote>\n

Details on why this happens and how to disable the prompt (if you want to) are in this KB article<\/p>\n

<\/a><\/p>\n

825765- You receive the "Opening this will run the following SQL command" message when you open a Word mail merge main document that is linked to a data source<\/a><\/p>\n

The DDE based mail merge showed the following SQL command<\/p>\n

SELECT * FROM C:\\ExampleFilePath\\ExampleFile.xls<\/em><\/p>\n

whereas the OLEDB based merge displayed<\/p>\n

SELECT * FROM ExampleSheetName$<\/em><\/p>\n

This was when I realised the problem was to do with how the data was being retrieved which then led me onto the DDE thing <\/p>\n

All good in the end!<\/p>\n","protected":false},"excerpt":{"rendered":"

It\u2019s weird how people panic when something is slightly different to how they expect I client called me this morning as she was trying to do a mail merge but it was behaving differently to how her other mail merges work Basically when she opened the Word document with the mail merge in, Excel also<\/p>\n

<\/span>Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[64],"tags":[],"class_list":["post-312","post","type-post","status-publish","format-standard","hentry","category-word"],"yoast_head":"\nOpening Excel During a Mail Merge - Andy's Techie Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Opening Excel During a Mail Merge - Andy's Techie Blog\" \/>\n<meta property=\"og:description\" content=\"It\u2019s weird how people panic when something is slightly different to how they expect I client called me this morning as she was trying to do a mail merge but it was behaving differently to how her other mail merges work Basically when she opened the Word document with the mail merge in, Excel alsoRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/\" \/>\n<meta property=\"og:site_name\" content=\"Andy's Techie Blog\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-03T10:52:58+00:00\" \/>\n<meta name=\"author\" content=\"Andy Parkes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andy Parkes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/\",\"url\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/\",\"name\":\"Opening Excel During a Mail Merge - Andy's Techie Blog\",\"isPartOf\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#website\"},\"datePublished\":\"2008-10-03T10:52:58+00:00\",\"dateModified\":\"2008-10-03T10:52:58+00:00\",\"author\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d\"},\"breadcrumb\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/andyparkes.co.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Opening Excel During a Mail Merge\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#website\",\"url\":\"https:\/\/andyparkes.co.uk\/blog\/\",\"name\":\"Andy's Techie Blog\",\"description\":\"Professional Geek\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/andyparkes.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d\",\"name\":\"Andy Parkes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g\",\"caption\":\"Andy Parkes\"},\"description\":\"Andy Parkes is Technical Director at Coventry based IT support company IBIT Solutions. Formerly, coordinator of AMITPRO and Microsoft Partner Area Lead for 2012-2013. He also isn't a fan of describing himself in the third person.\",\"sameAs\":[\"http:\/\/www.andyparkes.co.uk\/blog\"],\"url\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/author\/andyparkes\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Opening Excel During a Mail Merge - Andy's Techie Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/","og_locale":"en_US","og_type":"article","og_title":"Opening Excel During a Mail Merge - Andy's Techie Blog","og_description":"It\u2019s weird how people panic when something is slightly different to how they expect I client called me this morning as she was trying to do a mail merge but it was behaving differently to how her other mail merges work Basically when she opened the Word document with the mail merge in, Excel alsoRead More","og_url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/","og_site_name":"Andy's Techie Blog","article_published_time":"2008-10-03T10:52:58+00:00","author":"Andy Parkes","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Andy Parkes","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/","url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/","name":"Opening Excel During a Mail Merge - Andy's Techie Blog","isPartOf":{"@id":"https:\/\/andyparkes.co.uk\/blog\/#website"},"datePublished":"2008-10-03T10:52:58+00:00","dateModified":"2008-10-03T10:52:58+00:00","author":{"@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d"},"breadcrumb":{"@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/03\/opening-excel-during-a-mail-merge\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/andyparkes.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"Opening Excel During a Mail Merge"}]},{"@type":"WebSite","@id":"https:\/\/andyparkes.co.uk\/blog\/#website","url":"https:\/\/andyparkes.co.uk\/blog\/","name":"Andy's Techie Blog","description":"Professional Geek","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/andyparkes.co.uk\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d","name":"Andy Parkes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g","caption":"Andy Parkes"},"description":"Andy Parkes is Technical Director at Coventry based IT support company IBIT Solutions. Formerly, coordinator of AMITPRO and Microsoft Partner Area Lead for 2012-2013. He also isn't a fan of describing himself in the third person.","sameAs":["http:\/\/www.andyparkes.co.uk\/blog"],"url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/author\/andyparkes\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pmvJ6-52","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=312"}],"version-history":[{"count":0,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/312\/revisions"}],"wp:attachment":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}