Mergefield issue

ogoblag

New Member
Joined
May 20, 2011
Messages
15
Hello,

I have an Excel database linked via mailmerge to a Word blank. One of the mergefields keeps coming out as a date. Up to now I've tried formatting the Excel column, containing the data - as text, as general, as number (also tried on top of formatting as text to input " ' " qualifier infront). Even if I enter only text, the mergefield keeps coming out as a date.

I also tried altering the mergefield of the Word blank, with "\# ###0", "\# 0", but that didn't work also. Can anybody suggest how to change the format of the mergefield?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,524
Office Version
365
Platform
Windows
I believe that this is typically better handled from the Word mergefield side.

But could you post some examples of what this data looks like, and how you would like it displayed on your merge document?
It usually helps to know exactly what we are working with.
 

ogoblag

New Member
Joined
May 20, 2011
Messages
15
The column in question is always a four digit number and should be displayed exactly like that - a four digit number. No text/symbols in front or after it. Most commonly the number is 1000.

The blank as a whole is a letter in which the name of the recipient and his contact information changes, there are three possible issues to be disclosed him/her (8 strictly text mergefields).
The interesting thing is that there are two numeric fields, initially there was only one. The first one never gave me trouble. The second initially was included in the address as text string - it's a post code. The moment I inserted a separate column for that number it started giving me trouble - that's why I'm looking for something that's off with the settings of the database. The only difference between the numeric column that works correctly and the one that gives me trouble is that the second is used in a formula that determines the value of a third column (vlookup).
Could this be the problem?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,524
Office Version
365
Platform
Windows
What is the formula that is returning this 4 digit number that is causing problems?
If it is a VLOOKUP formula that is returning a 4 digit number, maybe try something like:
=TEXT(VLOOKUP(...),"0000")

Outside of that, you will want to handle it directly in the Word merge field.
 

ogoblag

New Member
Joined
May 20, 2011
Messages
15
The column with the number contains only the number. I tried formatting it as text, as general and as number (including manually adding " ' " infront of it. Nothing changes. Even when I input random letters "fsafa" it still comes out as a date.
Most probably I'll just revert to the version where the post code was a part of the address...

Thank you very much for your time and best of wishes for the New Year :)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,524
Office Version
365
Platform
Windows
Even when I input random letters "fsafa" it still comes out as a date.
If I am understanding that you are telling me correctly, that makes no sense to me.
If you have "fsafa" in an Excel cell, and are merging it into a Word document, and the Word document is showing a date in that field, then the issue almost certainly resides with how you built that Word merge field, and probably has nothing to do with the Excel field. I would recommend re-building that merge field.
 

ogoblag

New Member
Joined
May 20, 2011
Messages
15
Got me baffled too :)
I really tried fixing it before searching for advise - hoped you could hint me to something new.
Most probably will try remaking the whole word document, maybe also copying the excel data to a new document, but that will be further in time - work presses me and for now I'll have to do it the old way :)

Best regards,
Ognian
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,524
Office Version
365
Platform
Windows
Unfortuntely, I am afraid that without seeing it all, there isn't much more I can do.
 

Forum statistics

Threads
1,082,717
Messages
5,367,171
Members
400,946
Latest member
GiMan

Some videos you may like

This Week's Hot Topics

Top