Word for mac mail merge labels from excel not working

Word for mac mail merge labels from excel not working how to#

I would have thought that this was a common issue with mailmerge address fields but have searched here and googled and I can only seem to find similar questions with no solutions attached. I think I'm getting close to working it out but it's driving me mad! do NOT put this code on the last label on the page or it will skip a record. Try uninstalling & re-installing (preferably with the latest drivers from the maker's website). ItвЂ™s easy to make a mistake and end up with a page of labels you canвЂ™t. My problem comes from doing a mail merge from an excel list of addresses to several lables. Trying to print labels, envelopes, greeting cards, or anything else beyond standard letter-sized documents can be frustrating.

Word for mac mail merge labels from excel not working how to#

Thanks for showing me how to fix that the right way. We had another fix, which is to change the style to use word 2003 instead of 2007. Since the document 'prints' to PDF, a faulty printer and/or printer driver is the most likely problem for your 'real' printer. However it does fix that extra line that is created when hitting the enter key. Place a 'next record' after all the fields at the end of each label. Re: Documents created from mail merge won't print. This worked in scenarios where the address was 5 lines but if more or less, it would not behave and would either not show the postcode at all, OR show it twice. This works with a PC but I have not used a MAC. Word pulls out the information in your Excel columns and.

Each merge field corresponds to a piece of the address on the labelfirst name, last name, street address, and so on. I have tried setting up if then else rules and I made the assumption that all addresses would have at least 3 lines included so the first rule in place was The key thing to understand is that your column headers, or categories, in Excel will become merge fields (placeholders) in Word.

Obviously if all addlines are used, it looks fine. Where the address only has addlines 1-4 and a postcode, I'm getting blank lines between addline4 and the postcode. I have a document that has 7 mailmerge address fields addline1, addline2, addline3, addline4, addline5, addline6, Postcode. I have been looking into this all morning and am really hoping there is a simple solution to this.