Jan,
Printing to an Excel file requires you to ensure that there 'adequate' spacing between the columns, and possibly the rows. Otherwise you will find that some data is missing, as in your case. In the past I have found that it is best to create a wide report page size and spread the columns out, and as I recall, to use a small font. There was certainly a bit of 'trial and error' involved to ensure that all the data was transferred to the Excel spreadsheet. The other option is to just export the fields directly to an Excel file - that will be more reliable in my experience. Regards, John Docherty From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Barley Sent: Tuesday, 4 November 2008 5:25 a.m. To: RBASE-L Mailing List 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
