#1
|
|||
|
|||
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. Last edited by Charles Kenyon; 06-29-2017 at 03:14 PM. Reason: changed title to give better info about problem |
#2
|
||||
|
||||
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) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
You would want to accept all changes and turn off Track Changes.
|
#4
|
|||
|
|||
Quote:
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. |
#5
|
||||
|
||||
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) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#6
|
|||
|
|||
Thanks Graham.
Will give it a try. Les. |
#7
|
|||
|
|||
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. |
#8
|
||||
|
||||
Post the document so we can see what the problem is.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#9
|
|||
|
|||
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. |
#10
|
||||
|
||||
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) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Help Sending Mail Merge Document | dazwm | Mail Merge | 8 | 01-28-2014 01:00 PM |
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 |