Merging from Access

[Mardi Gras]

I am creating mail merges from access and excel, using UK addresses. Where in the fields I have accomodated for road numbers and house names.

When an address has a house name and no road number in the address, a number 0 is appearing where there is no number. This did not happen with Office 2000.

Any Ideas
Martin

I am using Office XP Pro

 

[Doug Robbins - Word MVP]

In Word from the Tools menu, select Options and then on the General tab,
check the "Confirm conversions at Open" item and try using the different
connection options that will be presented to you when you attach the
datasource to the mailmerge main document.

Alternatively, use and If ... then ... Else field in the mailmerge main
document to test the number mergefield and put "" if it equals 0.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I am creating mail merges from access and excel, using UK addresses.

Where in the fields I have accomodated for road numbers and house names.

When an address has a house name and no road number in the address, a

number 0 is appearing where there is no number. This did not happen with
Office 2000.

 

[Mardi Gras]

Interestingly, I found that if I convert the fields into text fields this silves the problem if import from excel, however if I link to excel even after making it a text field I still get a '0' if the field is left empty. Its a bodge way of doing it, but for my purposes it works.

It tells me I need instruction on Access.

Ta
Mardi Gras

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?TWFyZGkgR3Jhcw==?=,

Interestingly, I found that if I convert the fields into text fields this silves the

problem if import from excel, however if I link to excel even after making it a text field
I still get a '0' if the field is left empty. Its a bodge way of doing it, but for my
purposes it works.

It tells me I need instruction on Access.

Which connectin method did you choose then? ODBC, I take it. With DDE you wouldn't have
gotten a "0". But the other method - that would also work with the default OLE DB
connection - would be to truly convert the fields to text. You probably used Format/Cell?
you'd have to go over Data/Text to columns...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail