Office & Productivity Software forum


Word Mail Merge from excel: How to stop 0s from Merging

I have a mail merge from excel to Word and all the blank cells are coming through as 0's. How do I keep them blank or empty? Im using MS Word 2010. I saw post from 2007 and tried to use formula but that did not work. I tried to use IF...Then but I've never used it before so maybe I am doing something wrong it was just deleting the merge fields if it was 0.

Discussion is locked
You are posting a reply to: Word Mail Merge from excel: How to stop 0s from Merging
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Word Mail Merge from excel: How to stop 0s from Merging
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.

All Answers

Collapse -
Re: 0s

In reply to: Word Mail Merge from excel: How to stop 0s from Merging

Does it help if you format the fields as "text" in Excel in stead of "general".
Else fill them with a hard space (alt-0-1-6-0) as a work-around for not knowing how to use IF.

Collapse -
Re: 0s

In reply to: Re: 0s

Dear Kees_B,

Yes I already tried format the fields as "text". That did not help.

Im confused by your "Else fill them with a hard space (alt-0-1-6-0) as a work-around for not knowing how to use IF."

I could try the IF...Then. I did try something I read in earlier post. It was code from 2007 post. Maybe it was not working with my 2010 version. It was pulling the entire code into my letter as plain text.... I did not even get a error. Hmmm??? My second excel sheet is pulling info from master excel. I even tried to put code in master excel sheet and that did not work either. But I dont remember what was happening.

Collapse -
Re: confused

In reply to: Re: 0s

If I had said "Put an X in these empty fields" would you have been confused?
If I had said "Put an ë (alt-1-3-7) in these empty fields" would you have been confused?
Then why are you confused if I say "Put a hard space (alt-0-1-6-0) in these empty fields"?

You know what an X is, you know what an ë is, and tells what a hard space is.

Collapse -
OMG It worked!!!!!!!!!!!!!!!!

In reply to: Re: confused

OMG OMG if you were here I would HUG you. Happy

Ive been working on this for days.

So the "hard space" worked. Yay! So simple. My employees will need to get used to spacing in every box which is fine. There are only a few.

I was confused by "(alt-0-1-6-0)". I did not know what that meant.

I am very grateful and appreciative for your help.

Collapse -
Re: it worked

In reply to: OMG It worked!!!!!!!!!!!!!!!!

Thank you for telling. I really appreciate that.

If you send me a PM (private mail) after clicking on my username Kees_B, then I know your e-mail adress and can send you mine. Then - if you send me such a spreadsheet and the mail-merge document - I'll have a look if I can make the IF working. I've got a vague idea I once (long ago) did something like that myself, but I forgot all about the details, so I couldn't explain it to you in a post on short notice. It's kind of real programming, so you don't need to blame yourself you couldn't get it right.

I'm a professional IT-guy, so you can trust I won't make unintended use of your data.

Collapse -
Got your mail.

In reply to: OMG It worked!!!!!!!!!!!!!!!!

Will answer tonight (European time, that's afternoon in the USA).

Popular Forums

Computer Newbies 10,686 discussions
Computer Help 54,365 discussions
Laptops 21,181 discussions
Networking & Wireless 16,313 discussions
Phones 17,137 discussions
Security 31,287 discussions
TVs & Home Theaters 22,101 discussions
Windows 7 8,164 discussions
Windows 10 2,657 discussions


Here's Everything to Know About the 2019 Grammys

Find out how to watch the Grammy Awards if you don't have cable and more.