Home > Mail Merge > Word Could Not Re-establish A Dde Connection To Microsoft Excel To Complete The Current Task

Word Could Not Re-establish A Dde Connection To Microsoft Excel To Complete The Current Task

Contents

Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not When done, choose Save. My new office computer has windows 7 and MS Office Professional 2007. After you've set up and prepared your data source, you can perform a mail merge by using Dynamic Data Exchange (DDE) with the Step-by-Step Mail Merge Wizard or by using a http://nanextechnologies.com/mail-merge/how-to-move-data-from-excel-to-word.html

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Roberta" wrote in message ... When done, save your data source with a new file name. Likewise, you can't type or copy & paste the chevrons (ie ' ') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. I am having problems when I try to bring in the Excel file - message comes back saying "Word could not re-establish a DDE connection." However, I had just completed on

Word Could Not Re-establish A Dde Connection To Microsoft Excel To Complete The Current Task

Note that this suppresses 0s resulting from empty fields and from fields containing 0s. Staff Online Now Cookiegal Administrator crjdriver Moderator blues_harp28 Trusted Advisor DaveA Trusted Advisor Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick I need to use this email (mail merge) program quite frequently and it is becoming a very frustrating experience when it does not work, particularly when I just sent one batch Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

The second Excel file I was using to extract data contained two worksheets and the one I needed was the second sheet. Choose the .txt or .csv file you want, and then choose Import. Advertisement Recent Posts Computer randomly crashing Apexs replied Feb 13, 2017 at 11:17 AM Limited/No Internet Connection Cmoor replied Feb 13, 2017 at 11:13 AM Interactive PDF problems JiminSA replied Feb Mail Merge Formatting Issues It is a non-destructive tool that is compatible with Windows Vista, XP, 2003, 2000 and NT.

Sign up now! I need to use this email (mail merge) program quite frequently and it is becoming a very frustrating experience when it does not work, particularly when I just sent one batch Thanks! have a peek at these guys Guest Guest I have an excel spread that I pass between work and home.

However I get the following error message when I try to access the data "Word could not re-establish a DDE connection to complete the current task" Anyone can help with this? Mail Merge Currency Format Word 2010 Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... windows installer can't find file Help plz: laptop Dell weird moving... In the Text Import Wizard, in the Original data type pane, choose Delimited.

Mail Merge Number Format

Just click the sign up button to choose a username and then you can ask your own questions on the forum. http://www.techsupportforum.com/forums/f57/dde-problem-in-mail-merge-from-excel-478736.html To preserve numeric data you've formatted as a percentage or as currency during a mail merge, follow the instructions in the "Step 2: Use Dynamic Data Exchange (DDE) for a mail Word Could Not Re-establish A Dde Connection To Microsoft Excel To Complete The Current Task I never usually have any problems with mail merging to Excel. 2. Mail Merge Date Format Yes No Great!

To make those changes, go to the Mailings tab of the Ribbon and use the Start Mail Merge pulldown in the Start Mail Merge section of the Ribbon. More about the author At work I have > MSOFFICE2000 PRO. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Mailmerge Percentage Formatting To control percentage formatting in Word, add a formula and numeric picture switch to the mergefield. Mail Merge Number Format Decimal Places

Open your Excel data source. The Excel files have not been opened "Exclusively" and I have tried restarting my computer to see if they work but still get the same error message. Is this in Device manager normal?... check my blog Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "rmoritzky"

I am using Word and Excel 2007. Mail Merge Percentage Format Problem Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. Yes, my password is: Forgot your password?

Any suggetions are welcome.

To start viewing messages, select the forum that you want to visit from the selection below. Try Microsoft Edge, a fast and secure browser that's designed for Windows 10 Get started Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive The option to "Confirm file format conversion on open" has always been selected. Mail Merge Format Percentage The Excel workbook is damaged or corrupted.

A column that contains numerical data such as a percentage or a currency value, for example, can only be formatted after the file is imported. After doing that, then try attaching the new data source. -- Hope this helps. Format a column with numbers, for example, to match a specific category such as currency. news It should look something like {MERGEFIELD MyData}; .

Other possibilities include: . \# 0 for rounded whole numbers . \# ,0 for rounded whole numbers with a thousands separator . \# ,0.00 for numbers accurate to two decimal places, All the Word documents and Excel files are on my single laptop - no network or server involved.