Excel Text Converter For Mail Merge Mac Site:answers.microsoft.com

Excel workbook text converter not working for mail merge function. I'm trying to perform mail merge on a word document from an excel spread sheet. When I try to pick the data source (which is an excel file) Word needs to run an excel workbook text converter to pull out the appropriate fields. Mail merge does not work in Word 2016, when using Excel files as data sources, period. The 'text converter' was never needed in Windows versions, should not be in Mac versions. I have yet to find any possible workaround, with any new filename, changing to.xls or.xlsx or.xlsm or.csv.

Huge software glitch for sure. Went thru all the instructions from MS support site, the rep really had no clue. Just spent a few hours trying to figure out mail merge. I get same response too: 'needs to be opened by Excel workbook text converter' and when I hit ok it shuts down and application's closed. Don't recommend Office for Mac. In the market for better software now: Grrr. Thank you Paul.

Dec 30, 2016  Mail merge does not work in Word 2016, when using Excel files as data sources, period. The 'text converter' was never needed in Windows versions, should not be in Mac versions. I have yet to find any possible workaround, with any new filename, changing to.xls or.xlsx or.xlsm or.csv.

It quite likely will not be seen by anyone who didn't participate in the original conversation. Nothing personal:-), but that is what is referred to as hijacking a thread. If the solutions offered in a conversation don't work for you it's a clear indication that your situation is different in some way. Or if there was no absolute answer to a message posted more than 2-3 months ago it's most likely that your version of both the Office software & OS X are decidedly different from what the OP was using at the time s/he posted the message - this is particularly true of Office 2016 because it essentially has been 'assembled on the fly' since the initial release of the Preview version. In either case, it's best to post a new message of your own stating all pertinent info specific to your issue, even if it seems to be identical to what others have posted. That should include the version update level of both Office & OS X along with a complete & accurate description of the problem.

And that’s it! I have no idea what to do because I have exhausted all options I can think of. About 6 other people in my office got new computers and Microsoft programs IDENTICAL to my own and none are having this problem. Can ANYONE offer advice on how I can fix this?

FWIW, this is a fairly common occurrence, especially if the Excel File is rather old and/or created by certain versions of the program. Both the.xls &.xlsx file types have undergone modifications over the years & Word for Mac simply is not equipped with every conceivable filter. The standard fix is to open the file in Excel as you did, then Save As using a different file type, but it need not be.csv. An alternative approach is to open the data file in Excel, then copy the content to a new Excel workbook. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.

In that way, your posting is more likely to attract the attention of a wider range of responders & helps avoid confusion. At any rate, I'm glad you were able to resolve your issue.

But you didn't mention which of either one you are using. In general, using mail merge in Office 2016 with an Excel.xlsx workbook as the data source works fine. I suspect it works millions of times every day, in fact. So let's focus on why it doesn't work for you. The first thing is to make sure Office is up to date. Go to the Word menu and choose About Word.

The problem is that in both Word and Excel 2016 for Mac, the process fails. It is an awful bug in the programs, which frankly shows that Microsoft's quality control processes are negligent since it has yet to be rectified. Mail merge does not work in Word 2016, when using Excel files as data sources, period. The 'text converter' was never needed in Windows versions, should not be in Mac versions.

They will should all be shown within opening and closing Chevrons ( > and so on) • Now finish your document save and Print using the steps with in Mail Merge Window • At this time you can after saving Document go to Envelopes if you have a Printer capable of Printing envelopes and use the same Merge Excel document for Envelopes Save the Envelop Document as a Separate document you can call up again for another time. Myself I have a separate address Label Printer and I just use software from it to create labels. _________ Disclaimer: The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone, and do not reflect upon my position as a Community Moderator.

Any more ideas are welcome. Just as an observation because I do not know what is wrong, but Word 2013 would I think use the ACE database engine (the successor to Jet from Office 2007 onwards). The registry keys and file that I have for that here on a similar configuration are as follows: HKEY_LOCAL_MACHINE SOFTWARE WOW6432Node Microsoft Office 15.0 Access Connectivity Engine c: Program Files (x86) Common Files Microsoft Shared OFFICE15 ACEEXCL.DLL Probably worth at least having a look for that.

If my reply has helped, mark accordingly - Helpful or Answer Phillip M. Jones, C.E.T. This just explained the basic mail merge process.

Hi there, I am trying to do a Mail Merge using a Word document and an Excel database. When I try to open the Excel file I get the error message 'Could not find installable ISAM'. There ar some threads about this error message. Some about a connection string, some about file locations. Since I don't use a connection string, that seems not to be the answer but I do have some worries about the file locations or the registry entry. On my system the Msexcl40.dll is located in C: Windows SysWOW64 and in C: Windows WinSxS x86_microsoft-windows-m.components-jetexcel_31bf3856ad364e35_6.3.9600.16384_none_b2ae6f155dd6aa86.

The register key to JET is HKEY_LOCAL_MACHINE SOFTWARE Wow6432Node Microsoft Jet 4.0 Engines Excel So everything seems to be there, but it does not work. Using Word/Excel from Office 2013 Professional Plus 2013 32-bit Running Windows 8.1 Enterprise 64-bit. How are you connecting to the data source? Go to File>Options>Advanced and scroll down to the General Section of the dialog and check the box for 'Confirm file format conversion on open'. Then when you connect to the data source, a Confirm Data Source dialog should appear with the default OLE DB Database Files. Then when you click on OK in that dialog, you will be presented with a Select Table dialog in which you can select the source of the data in the Workbook that you have selected. Hope this helps, Doug Robbins - Word MVP dougrobbinsmvp@gmail.com Screen shots by Snagit from www.techsmith.com.

Just as an observation because I do not know what is wrong, but Word 2013 would I think use the ACE database engine (the successor to Jet from Office 2007 onwards). The registry keys and file that I have for that here on a similar configuration are as follows: HKEY_LOCAL_MACHINE SOFTWARE WOW6432Node Microsoft Office 15.0 Access Connectivity Engine c: Program Files (x86) Common Files Microsoft Shared OFFICE15 ACEEXCL.DLL Probably worth at least having a look for that. If you have the 365 version of Office, the regitry key structure is very different and the file is more likely to be in the following folder: C: Program Files Microsoft Office 15 root vfs ProgramFilesCommonX86 Microsoft Shared OFFICE15. Try going to the Control Panel>Uninstall a Program and then select Microsoft Office Professional Plus 2013 and then click on Change and then on Add or Remove Features and then check that Microsoft Access is set to 'Run all from My Computer' As a work-around, in the Confirm Data Source dialog, click the Show All box and then try connecting to the data source via the DDE method.

If I installed it, I would want to be sure I could restore my system tot he pre-install point. Other than asking around some more, I can only suggest that you try reparing office (Control Panel->Programs and Features->Uninstall or change a program->locate and select Office 2013 Professional plus, choose the Change option, then select the repair option.

To start off I am using Microsoft Office 2011 on a Mac. All programs are part of the same package so everything is 2011. I am trying to perform a Mail Merge and so far this is my issue, here is what I do step by step: 1) I go to Tools > Mail Merge Manager > Window pops up 2) I select “Create New” > “Form Letter” 3) I select “Get List” > “Open Data Source” 4) I select the Excel document that I want to use in my Mail Merge.

Hi I might be late with my answer. Anyway, to convert an e-mail into a.pdf document there is a better way than to copy/paste/convert or even having to download additional programs: Open the e-mail you want to convert.

I'm open to any other suggestions, especially if anyone's had this same experience and found success. Just found out what was missing to enable text converter to work on a Mac for those interested.

• Now open Word to a Blank Document. • Next Go to Mail Merge and add your headers (name, address, etc) to the page Select the excel File you just saved as the File to use for the merge information If you have used Mail merge in the past you should know how to add the items.

Open any Office application: 3. Make sure your Mac has a working internet connection 4. Go to the Help menu and choose Check for Updates 5. Let AutoUpdate check for and install updates 6.

I suggest you try to re-register the DLL - open a command prompt (sorry, I wil have to leave you to find out how to do that on Win 8.1) and run the following command: regsvr32 aceexcl.dll Peter, Finding the command prompt is not that a big problem:) Running rgsvr32 on the DLL seems not to give the desired results. A message pops up: The module 'aceexcl.dll' was loaded but the entry-point DllRegisterServer was not found. Make sure that 'aceexcl.dll' is a valid DLL OR OCX file and then try again. I was finally able to try the same and had the same result. Using the 32-bit version of regsvr32 in Windows syswow64 does not appear to make any difference. I was unable to find any information about this specific problem. There is a standalone distributable for the Access Database Engine on Microsoft's downloa's site, but it's for Office 2010 and I do not know whether or not it is suitable for Office 2013.

I have yet to find any possible workaround, with any new filename, changing to.xls or.xlsx or.xlsm or.csv. Nothing works. Yet another reason to use other programs than Office with a Mac. There have been many updates to Office 2016 and Mac OS X since both of these products became available.

So, i go to mailings tab start mail merge select recipients choose an existing list i choose the contacts xlsx list and open then it dies completely and will go no further any advice please? Try this (I have had to do a mail merge since switch to 2016 so I am guessing here: [note to others: anyone with better suggestion free to add suggestions] • First open Excel 2016 and open up your mail merge list. • Next Make sure the First Row have Header Titles such as: Name Address City State Zip Phone Email 1 Email 2 Web Page • Now do a Save As. And Change name slightly (append a letter or number adding 1, 2, 3, etc or a, b, c,, etc to end of name just before extensio — example: Business Mail List is saved as Business Mail Lista.) • Quit Excel (the converter in Word will not run if Excel is running).

I followed all the instructions listed on the MS Support site carefully- tried several different suggestions multiple times too! I honestly don't know why the application keeps closing on me after I reply 'Ok' to the 'Excel workbook text converter' like several other people have reported in this same thread.

You should have version 15.20 or 15.21 at this time. Then go to the Apple menu and choose About this Mac. What is your update level of Mac OS? Make sure your Mac has a working internet connection before checking for updates. Install Mac OS X updates followed by Office updates. Mac OS X updates: To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates. Office Updates To get the update: 1.

If you have the 365 version of Office, the regitry key structure is very different and the file is more likely to be in the following folder: C: Program Files Microsoft Office 15 root vfs ProgramFilesCommonX86 Microsoft Shared OFFICE15 Peter, I do find the ACEEXCL.DLL on the location mentioned. No registry keys pointing to this file however:( Hans.

Go to: FILE; PRINT; left click on your marked default printer (box between PRINTER and PRINT OPTIONS; this will open your list of available printers; select ADOBE PDF; click on PRINTER; this will open a window 'Save PDF File as'; the rest is history:-) Best Moggypop Thank you so much!!

Restart your Mac I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support. It's definitely a software issue, I have all the latest versions of Office 2016 and the OS for my Mac. I was on the phone for over an hour today w/ several tech reps in New Delhi on the MS 800 number and even they didn't know. To his credit, the rep told me he'd call me back tomorrow once he researched it. How is there no integration between Excel and Word for mail merge?

I have just installed 2016 on my mac (office 365) as an upgrade from 2011 which was on it and now the mail merge will not work. I open the word letter template first i get this; This file needs to be opened by the Excel Workbook text converter, which may pose a security risk if the file you are opening is a malicious file. Choose OK to open this file only if you are sure it is from a trusted source. I press ok then a pop up box - open document in workbook i do this and the word doc opens but with these messages Error!MergeField was not found in header record of data source.

I have saved this file as a couple of things:.xls,.xlsx,.csv, Excel Workbook, etc. 5) Once I select the file a window pops up titled “convert file' There are 15 different options to select: Text Only, MS-DOS Text, Rich Text Format, HTML Document, Single File Web Page, Unicode Text (this one is highlighted EVERYTIME this window opens), Word, Settings (14), Excel 3.x Worksheet, Excel 4.x Worksheet, Excel 5.x Worksheet, Excel 97-2004 Workbook, Excel Workbook, Excel Binary Workbook, Excel for Windows, Recover Text from Any File. 6) I have selected and tried EVERY SINGLE one of these options and a new window pops up to take its place: “This file needs to be opened by the Excel 97-2004 Workbook text converter, which may pose a security risk if the file you are opening is a malicious file. Choose OK to open this file only if you are sure it is from a trusted source” 7) I click OK because I know this file is fine. 8) A new window pops up saying: There was an Error Opening this File.

I believe you when you say it works for many which is why I'm stumped that it's not working for me. Maybe it's a Mac interface thing, I don't know. I only know that several reps on the MS Office hotline didn't know how to address it.

Save your data source excel file containing addresses as a '.csv' file from the drop down menu in the dialog box. This will convert the info from the cells into a single line of address info separated by commas. Then proceed w/ rest of instructions. Go to: Mailings in menu bar, Start Mail Merge, choose Labels - select the Avery label # or create own dimensions Select Recipients, Use an Existing File, open document Finish & Mail Merge - choose Insert fields (First name, Last Name, etc.) Worked nicely. Thanks to Anurag in Delhi who spent a good amount of time helping me. Sorry to be late to the party, but that's what often happens when someone tacks their message onto the tail end of an ancient conversation.

1 password 4 for mac. It's the same friggin' company! Aren't the departments communicating? Or are too many divisions being outsourced and no follow through?

Doug, Sorry for the late response. Busy this time of the year. Checked the Microsoft Office features. They are all set to: 'Run all from My Computer'. So nothing can be upgraded here. The DDE methode seems not to work, as the DDE methode only finds the first the first TAB of my spreadsheet.

Hi Doug, Thanks for answering. I connect to the data source by means of the Word Mail Merge utility. Up to last week I could select an Excel data source file just by selecting it. Now I run into trouble (after a total Office reinstall) First: I changed the check-box to 'Checked' Steps for mail merge (#-steps are new after checking the box) • First create an Excel file with some usable columns and lines • In Word: Mailings -> Select Recipients -> Use an existing list • Select the Excel (data source) file • Click Open • # The 'Confirm Data Source' dialog pops up • # Select 'OLE DB Database files' • # Click OK • Now the 'Could not find installable ISAM' message pops up. Still no success.:-( Hans.