Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!apple!well!casey From: casey@well.sf.ca.us (Kathleen Creighton) Newsgroups: comp.sys.ibm.pc Subject: Re: Question for Word-Perfect users Keywords: Word-Perfect & mailmerge Message-ID: <16330@well.sf.ca.us> Date: 22 Feb 90 14:26:58 GMT References: <13308@cbnewsd.ATT.COM> Reply-To: casey@well.UUCP (Kathleen Creighton) Distribution: usa Organization: Whole Earth 'Lectronic Link, Sausalito, CA Lines: 43 You might not be able to enter the special characters in Power Base, but you'll have to export your Power Base file as an ASCII file anyhow in order to use it with WordPerfect, right? I know nothing about Power Base, but this is what I do with Q&A files I export to make WordPerfect merge files: Q&A lets me make a template of fields for export, e.g.: *Name* *Address* *Suite/Floor* *City* *State* *Zip* So I add a "nonsense character" to what will be each ^R field and a different "nonsense character" to what will be the ^E field: *Name*@ *Address*@ *City*@ *State*@ *Zip*! When the file is exported in ASCII, the fields look like this: John Smith@ 111 Market@ San Francisco@ CA@ 94105! I retrieve that ASCII file into WordPerfect and do a global search and replace for @ with ^R and ! with ^E. It's very fast and very easy. Even if you aren't able to export files this way, you can create a macro in WordPerfect which will quickly add the field marks. The macro would go to the end of the four lines in my example and add ^R, then to the end of the fifth line and add ^E. This is also very easy. It just takes a few minutes longer to do. -- Kathleen Creighton {pacbell,hplabs,apple,ucbvax}!well!casey San Francisco