Jan, you will probably have to work with spacing on the report in order to capture all the data. Here is what I have had to do in the past. 1. Maker sure the font is set at arial 10. Easy for the data to be read. 2. Align all the data to the left. 3. Play with the vertical spacing so Excel will properly pickup all the data. The data is not transferring with the exact alignment between the programs for all the data to be properly displayed. You have to trick the programs with alignment in order to properly to receive and view the data. Gary
----- Original Message ---- From: Jan Barley <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, November 3, 2008 10:25:26 AM Subject: [RBASE-L] - Printing to Excel File Ok, y'all - I give up on this one! I am trying to print a membership directory. The format is like this: Company Name Contact Name Address City, State Zip Billing Address Billing CSZ Phone FAX EMail WebSite Sounds simple, but the member may or may not have a contact, billing address, phone, fax, email, website, or any combination of those elements missing. I have been "clever" enough to make enough variables to account for each missing element. The object here is to have the listing with no spaces for missing elements nor duplicated information. There are 3 possible variations on the address: 1. Street & Bill same: Address CSZ 2. Street & Bill different, CSZ same: Address Billing Address CSZ 3. Street & Bill different: Address CSZ Bill Address Bill CSZ As I said, I can actually get all this to work right, but when I go to print my report to an Excel file, it will randomly lose a contact name, email address, or something. For the life of me, I cannot figure out why this is happening. I would think it may be a misinterpretation of a delimiter but I can't seem to find a pattern to it. Can anyone help? Thanks in advance! Jan Barley
