 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2004Merging from Access
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 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.  SignaturePlease 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. > Any Ideas > Martin > > I am using Office XP Pro 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 > 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 [quoted text clipped - 15 lines] > > > > I am using Office XP Pro 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... > > 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. 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 :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.