Microsoft Office Forums Mailmerge sends sometimes with text and others in blank

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2019, 03:04 PM
yoyoauba yoyoauba is offline Mailmerge sends sometimes with text and others in blank Windows 10 Mailmerge sends sometimes with text and others in blank Office 2016
Novice
Mailmerge sends sometimes with text and others in blank
 
Join Date: Jan 2019
Posts: 4
yoyoauba is on a distinguished road
Unhappy Mailmerge sends sometimes with text and others in blank

Hello!





I hope someone can help me with this predicament:


I've been using mailmerge to send an attached information to 600 users, but some of them are missing the text and only keeping the colored background.


When it sends correctly, it looks like the attached example A01
when the sent message goes wrong, it looks like the attached example A02


This happens randomly, it can send correctly to 5, then miss the text at the following 12, then sending correctly again to 2 and so on.



I'm sending this email to 50 users at a time (every 1 hour), the way i build the email was adding two square shapes, the one in front with the text and the other behind with the picture, I group them, and send them. the first batch of 50, 7 came out wrong, the next one had 19, then 30 and the final batches only 2 came out correctly



Restarting word fixes the issue, but i'm not completely sure that's the solution. I went with a lower batch of 10 users at a time (max 50 per hour) and 599 out of 600 emails came out well.


I appreciate the help! (sorry for my english, not my native language)
Attached Images
File Type: jpg a01.jpg (69.9 KB, 13 views)
File Type: jpg a02.jpg (27.2 KB, 14 views)
Reply With Quote
  #2  
Old 01-18-2019, 09:44 PM
macropod's Avatar
macropod macropod is offline Mailmerge sends sometimes with text and others in blank Windows 7 64bit Mailmerge sends sometimes with text and others in blank Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Without actually seeing the problem document, it can be difficult for anyone to diagnose the issue. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 01-21-2019, 06:19 AM
yoyoauba yoyoauba is offline Mailmerge sends sometimes with text and others in blank Windows 10 Mailmerge sends sometimes with text and others in blank Office 2016
Novice
Mailmerge sends sometimes with text and others in blank
 
Join Date: Jan 2019
Posts: 4
yoyoauba is on a distinguished road
Default

Thank you Macropod for your reply!


I added the excel file i'm using for the emails (withought the actual emails or important information), but i can't upload the word since it's larger than 500 kb.


Here's the link to the word file i'm using:

https://my.pcloud.com/publink/show?c...wNKBB705dRcxPk


If i had to guess it might just be the file being overloaded. but perhaps i'm missing something.
Attached Files
File Type: xlsx prueba valores.xlsx (23.6 KB, 0 views)
Reply With Quote
  #4  
Old 01-21-2019, 02:40 PM
macropod's Avatar
macropod macropod is offline Mailmerge sends sometimes with text and others in blank Windows 7 64bit Mailmerge sends sometimes with text and others in blank Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The problem is undoubtedly related to the fact your document's surrounding logo is an image with a wrap format set to 'in front of text' and grouped with a textbox in which your actual text appears. Try the attached, which uses a table plus cropped header/footer images to replicate your layout.
Attached Files
File Type: docx Carta final valores alza cuotas 2019 (04-01-2019).docx (252.3 KB, 2 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 01-22-2019, 11:38 AM
yoyoauba yoyoauba is offline Mailmerge sends sometimes with text and others in blank Windows 10 Mailmerge sends sometimes with text and others in blank Office 2016
Novice
Mailmerge sends sometimes with text and others in blank
 
Join Date: Jan 2019
Posts: 4
yoyoauba is on a distinguished road
Default

I tried using different formats like you, but whenever I mailmerge it they come out wrong like in the attached file. (this is what it shows on Gmail and outlook using your file)

The only way for it to not change its format is by grouping the text box and the image.

i'm still trying to find ways to fix it, but so far, the previous file works whenever i don't abuse the quantity of senders.

Thank you so much for your time if i find another way i'll post it here too
Attached Images
File Type: png test 01.PNG (39.4 KB, 8 views)
Reply With Quote
  #6  
Old 01-22-2019, 01:57 PM
macropod's Avatar
macropod macropod is offline Mailmerge sends sometimes with text and others in blank Windows 7 64bit Mailmerge sends sometimes with text and others in blank Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Try the attached. If it still has issues, try changing the wrapping to in-line and, if necessary, adjusting the page margins.
Attached Files
File Type: docx Carta final valores alza cuotas 2019 (04-01-2019).docx (202.9 KB, 2 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 01-23-2019, 07:53 AM
yoyoauba yoyoauba is offline Mailmerge sends sometimes with text and others in blank Windows 10 Mailmerge sends sometimes with text and others in blank Office 2016
Novice
Mailmerge sends sometimes with text and others in blank
 
Join Date: Jan 2019
Posts: 4
yoyoauba is on a distinguished road
Default

This works beautifully!


i will have to test it out on a next batch of emails and hope for the lower background image to not cover the text if it's too long. (if the file decides to mess up again)



it might not be soon, but i will share my experience once i send once again to a big pile of emails.


Thank you for your time and effort <3
Reply With Quote
Reply

Tags
blank combine, mailmerge, word 16

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge sends sometimes with text and others in blank Remove blank table rows AFTER mailmerge Formd Mail Merge 5 05-11-2018 03:43 PM
Mailmerge sends sometimes with text and others in blank Suppress blank lines in mailmerge of excel reports into word document beefcake2000 Mail Merge 1 11-10-2017 12:54 PM
Email sends mailmerge file behind email rather than attachment TLC1974 Mail Merge 2 07-22-2016 12:53 AM
Mailmerge certain text using multiple if statements Debs Mail Merge 4 06-19-2014 03:34 AM
Mailmerge sends sometimes with text and others in blank How do you add text to email mailmerge? DerekScambler Mail Merge 10 04-19-2011 05:30 AM


All times are GMT -7. The time now is 01:32 PM.


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