Stephan,
This should be very straight forward, meaning if you have an Mac Excel 2008 (.xlsx) file as your mail merge data source, Mac Word 2008 will convert the file and use it as your data source. The Word converter for Excel files is included with the Office package. Let’s make sure you have the supporting files installed in the correct location. In the ‘Office Converter Support’ folder (located at <Start Up Disk>:Library:Application Support:Microsoft:Office Converter Support) you should see the following files:
MicrosoftChartPlugiIn.framework
MicrosoftComponentPlugIn.framework
MicrosoftOffice.framework
MicrosoftOLE.framework
MicrosoftOLEAutomation.framework
MicrosoftOleo.framework
MSXML.framework
OfficeArt.framework
Open XML for Charts
Open XML for Excel
Open XML for Excel.framework
SmartArt.framework
If you are not seeing all of these files in that folder, post a reply to the newsgroup and we’ll proceed from there.
Shawn Larson
Mac Word Test
Microsoft MacBU
--
This posting is provided 'AS IS' with no warranties, and confers no rights.
Find out everything about Microsoft Mac Newsgroups at:
[http://www.microsoft.com/mac/community/community.aspx?pid=newsgroups]
Check out product updates and news & info at: [http://www.microsoft.com//mac]
This should be very straight forward, meaning if you have an Mac Excel 2008 (.xlsx) file as your mail merge data source, Mac Word 2008 will convert the file and use it as your data source. The Word converter for Excel files is included with the Office package. Let’s make sure you have the supporting files installed in the correct location. In the ‘Office Converter Support’ folder (located at <Start Up Disk>:Library:Application Support:Microsoft:Office Converter Support) you should see the following files:
MicrosoftChartPlugiIn.framework
MicrosoftComponentPlugIn.framework
MicrosoftOffice.framework
MicrosoftOLE.framework
MicrosoftOLEAutomation.framework
MicrosoftOleo.framework
MSXML.framework
OfficeArt.framework
Open XML for Charts
Open XML for Excel
Open XML for Excel.framework
SmartArt.framework
If you are not seeing all of these files in that folder, post a reply to the newsgroup and we’ll proceed from there.
Shawn Larson
Mac Word Test
Microsoft MacBU
--
This posting is provided 'AS IS' with no warranties, and confers no rights.
Find out everything about Microsoft Mac Newsgroups at:
[http://www.microsoft.com/mac/community/community.aspx?pid=newsgroups]
Check out product updates and news & info at: [http://www.microsoft.com//mac]
Mail Merge Word For Mac With Excel Converter Not Found To Remove
For example, instead of displaying 1.0014, Mail Merge showed 1.0013. But let’s say that you can’t or don’t want to change your Excel spreadsheet. Well, there is something we can do in Word: 2. Use a “Numeric Switch” in Word. The second way to cajole Mail Merge into displaying numbers from Excel correctly is to modify the Word. A few times my colleagues and I have experienced the situation where a mail merge template lose its connection to its data source (in my client’s case, an Excel spreadsheet). I suspect it’s because Word is storing the file path to the data source somewhere that we can’t see or find. May 09, 2019 Step Five: Performing the Mail Merge. Now to watch the magic happen. On the “Mailings” tab, click “Finish & Merge.” From the drop-down menu that appears, select “Edit Individual Documents.” The “Merge to New Document” window will appear. Select “All” and then click “OK.” Your list from Excel will now be merged into the. If you're already using an Excel spreadsheet as your data source for a mail merge in Word, go to Step 2 in this topic. If the data source is a.txt or a.csv file that contains your Gmail contacts, for example, use the Text Import Wizard to set up your data inExcel.
You might find that you have difficulty formatting numbers properly when using Mail Merge in Microsoft Word. This can be a problem if you are calculating numbers in your source (especially when your source is an Excel spreadsheet or Access database). For example, you might have a simple gradebook that averages three grades to get a final grade. If a student has grades of 90, 95, and 99, his average will be 94.66666666666666666.... Excel or Access can easily be set to format the numbers to 1 or 2 decimal places, but that formatting will not necessarily show up in your mail merge document. You do not want to send home a mail merge letter to your student's parents congratulating them on their daughter's outstanding average of 94.66666666667 in your class. The letter would be much better if it congratulated them on their daughter's average of 94.7.
In Word 97, here is what you do:
(1) Create the mail merge letter as you normally would, include the field for the final grade. Your merged field will look like this: «FinalGrade»
(2) Right click your mouse on the field and select the Toggle Field Codes option from the popup menu. Your merged field will now look like this: {MERGEFIELD FinalGrade }. This is the same thing as before; it is merely showing the information to you in a different way.
(3) Next, you need to insert a special code to tell Word 97 that you want to round this off to one decimal place. After the name of the field (FinalGrade) and before the bold close curly bracket, type the following: #0.0
(4) Your merged field now looks like this: {MERGEFIELD FinalGrade #0.0}. This will round your number to one decimal place, so in the above example the number will be 94.7. If you want to round to two decimal places, use #0.00 in your merge field. If you want the number to have a dollar sign before it (for anything that is money), use #$# in your merge field. If you want commas in your number, use ##,### in your merge field. If you want dollars, rounded to two decimal places with commas, use #$#,##0.00 in your merge field.
Return to ED303 Home Page.
This page was prepared by Dr. David M. Marcovitz.
Mail Merge Word For Mac With Excel Converter Not Found To Print
Last Updated: July 31, 1998