Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2021, 06:11 AM
Cosmica67 Cosmica67 is offline How to Mail Merge with coloured text Windows 10 How to Mail Merge with coloured text Office 2016
Novice
How to Mail Merge with coloured text
 
Join Date: Dec 2019
Posts: 3
Cosmica67 is on a distinguished road
Default How to Mail Merge with coloured text

Hi,



I have a problem that I hope someone will be able to give me instructions to solve fairly easily.

I have coloured text in a spreadsheet, which I need to also be coloured in the mail merged Word doc.

However, the mail merged document text is coming out in the default black text, when it is red/blue/green in the spreadsheet.

Is there a simple work around that will keep the coloured text in the mail merged Word document?

Thanks for looking!
Reply With Quote
  #2  
Old 11-26-2021, 10:45 PM
gmayor's Avatar
gmayor gmayor is offline How to Mail Merge with coloured text Windows 10 How to Mail Merge with coloured text Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Set the merge document type to normal word document.
Select Word Options > Advanced > General > Confirm file format conversion on open. Then when you re-attach the data source to the mail merge main document, you will be given the option of selecting the connection type. Check 'Show all' and pick the option to connect to Excel using the DDE method of connection which should read the data as you have it formatted in the table.

Do however note that DDE can be somewhat unreliable and normally is best avoided.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 11-27-2021, 07:48 AM
Cosmica67 Cosmica67 is offline How to Mail Merge with coloured text Windows 10 How to Mail Merge with coloured text Office 2016
Novice
How to Mail Merge with coloured text
 
Join Date: Dec 2019
Posts: 3
Cosmica67 is on a distinguished road
Default

Hi,

Thanks for answering. I have already connected to Excel using the DDE method and the text isn't mail merged in the same colour as what shows on the Excel file.

I hadn't set the Word doc to normal word document but when I did change it, it made no difference.

Thanks for looking though.
Reply With Quote
  #4  
Old 11-27-2021, 09:38 PM
gmayor's Avatar
gmayor gmayor is offline How to Mail Merge with coloured text Windows 10 How to Mail Merge with coloured text Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

It may be possible to use a macro to provide the colouring, but that would depend on what conditions determine the colour of the data. You can run a macro from
https://www.gmayor.com/email_merge_addin.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 11-28-2021, 04:35 PM
macropod's Avatar
macropod macropod is offline How to Mail Merge with coloured text Windows 10 How to Mail Merge with coloured text Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Cross-posted at: How to Mail Merge with output that matches formatting in Excel source file
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 11-29-2021, 07:12 AM
Cosmica67 Cosmica67 is offline How to Mail Merge with coloured text Windows 10 How to Mail Merge with coloured text Office 2016
Novice
How to Mail Merge with coloured text
 
Join Date: Dec 2019
Posts: 3
Cosmica67 is on a distinguished road
Default

Sorry, I didn't realise cross posting was a thing.

I will adhere to the rules if I cross post in the future.

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Mail Merge with coloured text Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Alfred Mail Merge 2 05-23-2017 10:59 PM
Macro to find coloured text and replace with form-field/formtext containing that text tarktran Word VBA 1 11-26-2014 08:12 AM
How to Mail Merge with coloured text Coloured text printing - control ? Wombat Word 6 09-21-2014 06:07 AM
Can you have Individual Text in a Mail Merge SiberianBreaks21 Mail Merge 1 07-25-2014 05:01 PM
Macro to mark non-coloured/non-highlighted text as hidden PeterB Word 0 10-28-2009 07:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 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