Jan, what is missing is the vertical spacing on your RBase Report. You will need to use trial and error on the vertical spacing for Excel to pickup the all the data from the report. Gary
----- Original Message ---- From: Jan Barley <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, November 3, 2008 1:05:35 PM Subject: [RBASE-L] - Re: Printing to Excel File Hmmm... I use Arial 10 as my default font. All fields are left aligned. I ended up using one field (Variable memo) to hold all the info I need. I use a (char(10)) to seperate each line I need to create. Do I also need to LJS them? Here's my list of variables: 1 : TEXT : D : vattn = (ifgt((slen(attn)),1,(attn+(char(10))+addr1+(char(10))),(addr1+(char(10))))) 2 : TEXT : D : vadd = (.vattn+(ifexists(addr2,(addr2+(char(10))+csz),(csz)))) 3 : TEXT : D : vbcsz = (ifgt((slen(bcsz)),1,((char(10))+bcsz),' ')) 4 : TEXT : D : vbadd = ((ifgt((slen(baddr1)),1,((char(10))+baddr1),' '))+(ifgt((slen(baddr2)),1,((char(10))+.vbcsz),.vbcsz))) 5 : TEXT : D : vem = (ifgt((slen(email)),1,((char(10))+email),email)) 6 : TEXT : D : vws = (ifgt((slen(website)),1,((char(10))+website),website)) 7 : TEXT : D : vphone = (ifgt((slen(phone)),1,((char(10))+phone),phone)) 8 : TEXT : D : vfax = (ifgt((slen(fax)),1,((char(10))+fax),fax)) 9 : TEXT : D : vaddress = (.vadd+(ifgt((slen(.vbadd)),1,.vbadd,' '))+(ifgt((slen(.vphone)),1,.vphone,' '))+(ifgt((slen(.vfax)),1,.vfax,' '))+(ifgt((slen(.vem)),1,.vem,' '))+(ifgt((slen(.vws)),1,.vws,' '))) I had to check to see if the field was longer than 1 char because it counts the space. On the report, the only field I use is the vaddress. I had to put the (char(10)) before the next field or I would get a space, then the field. I cannot simply export the data as I need to sort it by business category and don't want the business category to show for each business. Also, I don't know how to manipulate the Excel - if I click to Open after Generate, it creates a new worksheet! I have tried this in both my Excel 2002 and Excel 2007 and get the same results! Also am using the latest build for 7.6. This is so strange! The Excel drops different fields each time : the first record dropped the contact name and email the second record dropped the phone number the third record dropped the address the fourth record dropped the FAX the fifth record dropped the street address the sixth record dropped the city Jan
