Microsoft Office Forums Mail Merge - Word primary, Excel secondary - track changes marking

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2017, 01:27 AM
voyagerone voyagerone is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 8 Mail Merge - Word primary, Excel secondary - track changes marking Office 2013
Novice
Mail Merge - Word primary, Excel secondary - track changes marking
 
Join Date: Aug 2015
Posts: 15
voyagerone is on a distinguished road
Default Mail Merge - Word primary, Excel secondary - track changes marking

Using a 'Word' document for mail merge letter. Using a database in Excel.
The mail merge process is simple enough. Before sending out a few hundred mail merge emails, I always like to send one to myself to check that all is ok. Lucky I did. I have a few email addresses.
The document received is completely wrong with lines crossed out and with words replacing other words. Some text is in red. I thought it was a mark up problem so I cancelled all the markup settings and stated 'No markup', but still the same.


I don't know where to look to solve the problem. It must be a problem with a setting somewhere. See screenshot.
Any assistance is appreciated.
Cheers,
L.
Attached Images
File Type: jpg Word Vintage.JPG (58.6 KB, 10 views)

Last edited by Charles Kenyon; 06-29-2017 at 03:14 PM. Reason: changed title to give better info about problem
Reply With Quote
  #2  
Old 06-29-2017, 04:01 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 10 Mail Merge - Word primary, Excel secondary - track changes marking Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,757
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

It looks like a markup problem. Did you accept the changes? If that doesn't resolve it you'll need to post the merge document so we can see what the problem is directly.

You may find http://www.gmayor.com/ManyToOne.htm useful for this sort of merge to e-mail.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 06-29-2017, 03:13 PM
Charles Kenyon Charles Kenyon is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 10 Mail Merge - Word primary, Excel secondary - track changes marking Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,863
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

You would want to accept all changes and turn off Track Changes.
Reply With Quote
  #4  
Old 06-29-2017, 09:06 PM
voyagerone voyagerone is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 8 Mail Merge - Word primary, Excel secondary - track changes marking Office 2013
Novice
Mail Merge - Word primary, Excel secondary - track changes marking
 
Join Date: Aug 2015
Posts: 15
voyagerone is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
You would want to accept all changes and turn off Track Changes.
Thanks Charles. That worked thanks, but another problem has arisen.
My 'Word' document when emailed back to me has altered considerably, placing pictures in the wrong positions all over the document. It looks bad to say the least.
I have just had 'Microsoft Home and Business 2016' installed. The document which is incorrect was made from MS Word 2013. I would have thought there would have been no problem between the two. Maybe there isn't and it is something else. I can attach the complete document if necessary for you to view.
What I will do is to construct the whole new document in 2016 (about 5 pages) send it to myself and then see if it differs. I have emailed documents like this for many years with no problems at all.
Any suggestions please?
Cheers,
Les.
Reply With Quote
  #5  
Old 06-29-2017, 10:44 PM
gmayor's Avatar
gmayor gmayor is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 10 Mail Merge - Word primary, Excel secondary - track changes marking Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,757
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Word documents and formatted HTML e-mail are entirely different and formatting changes are not uncommon. If you want to avoid formatting changes you should send the document as an attachment preferably in PDF format and stick to standard Windows fonts.

You should at the very least check the output with Word's web view.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 06-30-2017, 12:35 AM
voyagerone voyagerone is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 8 Mail Merge - Word primary, Excel secondary - track changes marking Office 2013
Novice
Mail Merge - Word primary, Excel secondary - track changes marking
 
Join Date: Aug 2015
Posts: 15
voyagerone is on a distinguished road
Default

Thanks Graham.
Will give it a try.
Les.
Reply With Quote
  #7  
Old 06-30-2017, 02:37 AM
voyagerone voyagerone is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 8 Mail Merge - Word primary, Excel secondary - track changes marking Office 2013
Novice
Mail Merge - Word primary, Excel secondary - track changes marking
 
Join Date: Aug 2015
Posts: 15
voyagerone is on a distinguished road
Default

Graham.
I have completely made up a new 8 page document with text and pictures. It looks great. I emailed it to myself and it came back as a huge mess. Nothing was right. I had previously grouped pics together to hopefully stop them flying off into cyberspace and moving around in the document. This was using the very latest '2016 Word'. I have never seen such a mess. It is very disconcerting. I have been using MS Word now for some 20 years without problems.
Any suggestions. apart from using a very large hammer?
Cheers,
Les.
Reply With Quote
  #8  
Old 06-30-2017, 03:30 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 10 Mail Merge - Word primary, Excel secondary - track changes marking Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,757
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Post the document so we can see what the problem is.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #9  
Old 06-30-2017, 06:54 PM
voyagerone voyagerone is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 8 Mail Merge - Word primary, Excel secondary - track changes marking Office 2013
Novice
Mail Merge - Word primary, Excel secondary - track changes marking
 
Join Date: Aug 2015
Posts: 15
voyagerone is on a distinguished road
Default mail merge.

Hi Graham.
This site won't allow. Says it is too big a file. I have copied part of it as screenshots which are attached. May give you some idea.

Not getting far am I.
Les.

I will send further screenshots.
Attached Images
File Type: jpg Capture 26.JPG (43.7 KB, 6 views)
File Type: jpg Capture 27.JPG (71.5 KB, 6 views)
File Type: jpg Capture 28.JPG (83.7 KB, 6 views)
File Type: jpg Capture 29.JPG (83.7 KB, 6 views)
File Type: jpg Capture 30.JPG (105.4 KB, 6 views)
Reply With Quote
  #10  
Old 06-30-2017, 08:55 PM
gmayor's Avatar
gmayor gmayor is offline Mail Merge - Word primary, Excel secondary - track changes marking Windows 10 Mail Merge - Word primary, Excel secondary - track changes marking Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,757
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Your document appears to feature extensive use of floating wrapped images. Did you check Word's Web view to discover what happens to such images when converted to html layout?

I strongly urge you to use in-line images and borderless tables to lay out your document and then you will have fewer problems.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Word primary, Excel secondary - track changes marking Word 2010 - directory mail merge - two separate group of data in one document htsu Mail Merge 2 03-07-2016 03:10 PM
Creating a table in one document of WORD from EXCEL with Mail Merge Joseph.Comerford@bentley. Mail Merge 1 04-18-2015 01:19 AM
Mail Merge - Word primary, Excel secondary - track changes marking Help Sending Mail Merge Document dazwm Mail Merge 8 01-28-2014 01:00 PM
Mail Merge - Word primary, Excel secondary - track changes marking Formatting in mail merge document OnTheCouch Mail Merge 1 09-29-2013 07:05 PM
converting a word document to a data file for mail merge drsuis Mail Merge 4 02-21-2013 03:34 PM


All times are GMT -7. The time now is 05:00 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft