Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2016, 01:37 PM
cowanji cowanji is offline Mail merge stripping bold, italic formatting Mac OS X Mail merge stripping bold, italic formatting Office for Mac 2011
Novice
Mail merge stripping bold, italic formatting
 
Join Date: Mar 2016
Posts: 1
cowanji is on a distinguished road
Arrow Mail merge stripping bold, italic formatting

I am having the same issue working on a Mac, as well as a PC.



I have created a mail merge using data from Excel. Sample files attached.

All seems to be going well, except that any text that is formatted bold and italic text in excel is being stripped from the description text. We need this for APA formatting.

Any suggestions would be greatly appreciated!

Jim Cowan
Attached Files
File Type: xlsx 2016CAS_Part2_SampleData.xlsx (12.6 KB, 8 views)
File Type: docx 2016CAS_Part2.docx (20.8 KB, 6 views)
Reply With Quote
  #2  
Old 03-18-2016, 03:49 PM
macropod's Avatar
macropod macropod is offline Mail merge stripping bold, italic formatting Windows 7 64bit Mail merge stripping bold, italic formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That behaviour is normal - a standard mailmerge transfers the data, not character formatting. If you need multiple formats, you'll need a separate data field and corresponding mergefield for each string in that format.

Alternatively, you might try using the older DDE mailmerge connection. To do that, see: https://support.office.com/en-us/art...C-ACD027D92A00. Note: I'm not sure if even that will retain character formats. In any event, DDE is essentially what Macs use so, if the formats aren't being preserved there, I doubt switching to DDE on a PC would make any difference.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
formatting, macintosh, merge



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge stripping bold, italic formatting Formatting numbers in a mail merge Dibble Mail Merge 5 01-04-2016 04:17 PM
Mail merge stripping bold, italic formatting Formatting changes after mail merge staceynairn Mail Merge 1 06-03-2014 06:29 PM
Mail merge stripping bold, italic formatting Formatting in mail merge document OnTheCouch Mail Merge 1 09-29-2013 07:05 PM
Can't use Bold and Italic khmerguy Word 3 03-31-2011 12:48 PM
Mail merge stripping bold, italic formatting Can't print bold or italic text cornettd PowerPoint 1 05-10-2010 10:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft