Merge format switch issue?

Hello,

We are doing a mail merge. Data source is excel file with cell contents "X"
(quotes are not applicable). We are merging the X into a word document but
the value comes through as 0. What formatting switch can we apply to always
indicate an alpha for merge field. The results will be either X in the check
box or nothing, and this is always the case. So if merge encounters some
screwy excel format and doesn't know how to apply the value we only want a X
or nothing at all no 0 ever.

Thanks.
--
"Gambling is illegal @ Bushwood and I never slice."

My original post was fixed by formatting the excel data source cells as
generic instead of numeric. Not sure why cell contents of only alpha could
ever be construed as 0, but I guess the newer version of word infers much
more than it used to. This is being done on Office 2007 applications.

Separate issue now where we have an EIN or Address field. My format switch
for EIN is screwing up the address fields. How can I type a condition for
format to EIN if cell contents numeric only and if any instance of alpha
character utilize the address formatting?

Thanks for any help.
--
"Gambling is illegal @ Bushwood and I never slice."


"bushwood" wrote:

Hello,

We are doing a mail merge. Data source is excel file with cell contents "X"
(quotes are not applicable). We are merging the X into a word document but
the value comes through as 0. What formatting switch can we apply to always
indicate an alpha for merge field. The results will be either X in the check
box or nothing, and this is always the case. So if merge encounters some
screwy excel format and doesn't know how to apply the value we only want a X
or nothing at all no 0 ever.

Thanks.
--
"Gambling is illegal @ Bushwood and I never slice."

Can you continue this in the Mailmerge.fields group where I have posted
a response - if not an answer - to your message.

FWIW a description of some of the issues is at

http://tips.pjmsn.me.uk/t0003.htm


Peter Jamieson

http://tips.pjmsn.me.uk

On 28/04/2010 22:47, bushwood wrote:
My original post was fixed by formatting the excel data source cells as
generic instead of numeric. Not sure why cell contents of only alpha could
ever be construed as 0, but I guess the newer version of word infers much
more than it used to. This is being done on Office 2007 applications.

Separate issue now where we have an EIN or Address field. My format switch
for EIN is screwing up the address fields. How can I type a condition for
format to EIN if cell contents numeric only and if any instance of alpha
character utilize the address formatting?

Thanks for any help.

The following field construction might work

{ IF { = { MERGEFIELD Address } - { MERGEFIELD Address } } = 0 { MERGEFIELD
Address [with EIN Switch] } { MERGEFIELD Address } }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"bushwood" wrote in message
...
My original post was fixed by formatting the excel data source cells as
generic instead of numeric. Not sure why cell contents of only alpha
could
ever be construed as 0, but I guess the newer version of word infers much
more than it used to. This is being done on Office 2007 applications.

Separate issue now where we have an EIN or Address field. My format
switch
for EIN is screwing up the address fields. How can I type a condition for
format to EIN if cell contents numeric only and if any instance of alpha
character utilize the address formatting?

Thanks for any help.
--
"Gambling is illegal @ Bushwood and I never slice."


"bushwood" wrote:

Hello,

We are doing a mail merge. Data source is excel file with cell contents
"X"
(quotes are not applicable). We are merging the X into a word document
but
the value comes through as 0. What formatting switch can we apply to
always
indicate an alpha for merge field. The results will be either X in the
check
box or nothing, and this is always the case. So if merge encounters some
screwy excel format and doesn't know how to apply the value we only want
a X
or nothing at all no 0 ever.

Thanks.
--
"Gambling is illegal @ Bushwood and I never slice."

Yes sorry I posted here first then clarified that the inherent formatting of
excel fixed the 0 values being placed in merged document for an alpha
character (changed from numeric format to general format in source data file
fixed the 0 value issue).

Then I saw a separate discussion area for mailmerge specific and posted
again there.

I am having a hard time with a condition for format switch based on cell
content as opposed to cell value.

merge will encounter blanks, text, numeric, text + numeric. We only want a
switch applied to numeric. please continue responses in mailmerge section of
word discussion board thanks!
--
"Gambling is illegal @ Bushwood and I never slice."


"Peter Jamieson" wrote:

Can you continue this in the Mailmerge.fields group where I have posted
a response - if not an answer - to your message.

FWIW a description of some of the issues is at

http://tips.pjmsn.me.uk/t0003.htm


Peter Jamieson

http://tips.pjmsn.me.uk

On 28/04/2010 22:47, bushwood wrote:
My original post was fixed by formatting the excel data source cells as
generic instead of numeric. Not sure why cell contents of only alpha could
ever be construed as 0, but I guess the newer version of word infers much
more than it used to. This is being done on Office 2007 applications.

Separate issue now where we have an EIN or Address field. My format switch
for EIN is screwing up the address fields. How can I type a condition for
format to EIN if cell contents numeric only and if any instance of alpha
character utilize the address formatting?

Thanks for any help.
.