Mailing
Solved
BmV Posted messages 43611 Registration date Status Moderator Last intervention -
Hello,
Could someone tell me if it is possible, when doing mail merge (using an Excel file), to ensure that the cells containing ''/'' do not appear during the merge in Word?
It looks ugly, but at the same time I have to put this mark in my empty cells; otherwise, Excel puts a "0", which also carries over during the merge.
Thank you for your responses.
Séverine.
5 answers
Hello
You may want to look at the options for displaying zeros in Excel that would affect the mail merge.
Hello,
In Excel, I know how to do it.
What I'm having trouble with is that this 0 appears in my Word document even though there is normally nothing to enter (for example: a second address where the Excel cell is empty, I don't want it to appear in my letter because in terms of presentation, it's not aesthetic).
OK
Apparently, we will need to "be clever" here too...
What if instead of the " / " in the table, we made a " - " or even a ". ", or any other character that is much more discreet later in the letter? Would that be more acceptable?
Or, in the Excel table, we add a column that would act as a "duplicate" for the one likely to contain the famous " / ".
Explanation:
- we let Excel insert the " / " in the designated column
- in the artificially added column, we put a formula "if F5 is not "/", then G5=F5 else G5="" " and the target of the field in the letter will be G5 and not F5.
So if there is anywhere a "/" in Excel, it will be replaced by blank in the letter... (Also, be careful to properly size this blank.... )
Hello,
I don't understand why you don't just leave the cell empty. An empty cell doesn't return 0. Then in Word, you can easily manage the "empty" paragraph return using an IF. It's more of a Word question.
m@rina
Hello Marina,
Maybe because when I leave my cell empty, I don’t know how to make it so that the 0 doesn’t appear in my merge with Word (I may not have specified that the table I’m working on pulls its data from another sheet in my file and it’s when I go to fetch my cell and it’s empty that the result shows 0, and of course, this 0 then carries over to Word).
Good evening
Look here:
https://www.faqword.com/index.php/word/publipostage/le-champ-bloc-dadresse-dans-le-publipostage-word
m@rina
The same process as mine above.
Except that you solve it classically with a completely relevant formula while I cheat by adding a column, which I personally prefer based on experience, as it leaves full freedom to configure the "native" cell as needed without worrying about the report to the letter field ....