Prev: Why won't my printer print clipart from Word?
Next: Word 2007 Document Preview
From: bushwood on 28 Apr 2010 17:47
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."
From: Peter Jamieson on 28 Apr 2010 18:32
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.
From: Doug Robbins - Word MVP on 28 Apr 2010 18:33
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" <bushwood(a)discussions.microsoft.com> wrote in message
news:B77FCC51-6E8B-45DC-8A9E-7C88FC1E82C4(a)microsoft.com...
> 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."

From: bushwood on 28 Apr 2010 20:21
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.
> .
>
 | 
Pages: 1
Prev: Why won't my printer print clipart from Word?
Next: Word 2007 Document Preview