Recent content by kawnz

Sorry, I guess I am not being very clear. There is one large document that includes all letters. As stated in my first post, there could be 10000+ pages worth of accounts in the file generated by the billing system. The Company name is our company name, and is listed at the top of every page...

This is an example of what the letter looks like. The page breaks in the text file look like that little box character []

Yes, that is essentially what I am looking for. The edit report is more precise and is able to 'weed out' based on more criteria, like users, etc. The letters only have one criteria: errors So, if there are other criteria that we want to exclude from the letters, we have to do it manually. My...

let me clarify... essentially what I want, is for word to do a find of each account number in the excel file, and then delete the page if it is there. I figure that I can have the lady do filters with delete/send and then have the word doc look through the spreadsheet to select the pages to...

where do you find personal.xls? I tried to search my C:\ drive and nothing showed. I did however, create the sheet.xls and book.xls files and places them in my XLSTART directory. Should I do the same with personal.xls? i.e. create it and save it?

Our medical billing system has the ability to generate letters asking our clients to supply information that was missing on the original order. We need this information in order to bill insurance. The system generates two things: an edit report that our employees can use to fix any errors that...

this page might help you utilize the iserror function to show your custom error message http://spreadsheets.about.com/cs/excelfunction1/a/iserrorfunction.htm

My many thanks to Frederico for his continued help with the processing of this file.

too right about styles and structure. I don't use them as much as I should, but we have people here that still put spaces instead of a tab, and use an * to signify a bullet and then hit enter and spaces until the beginning of the next line lines up with the first.

Thank you Dale. I just fired of an e-mail to you with the file and more details.

I have a spreadsheet with three worksheets: the first worksheet has VA insurance data the second worksheet has TN insurance data the other has revisions that were posted to the first worksheet. my manager wants the revision sheet at the bottom of the data worksheet, but then the data worksheet...

what about saving this file to a PDF and then distributing the PDF? You can prevent printing in a PDF, can't you?

I have a text file that I am unable to import into excel. The file is over 2000 pages long when I load it into word. Is there a way to save this text file into shorter text files - say 20 files of about 100 pages? How would I do this?

I am using excel 97. I tried setting the sheet to import at row 65536 but it won't allow me to set this value to anything over 32767

thanks, will try the two options and see which works best for my situation. the deal was that I was creating procedures using the job descriptions file, because that is what was sent to me to begin with. The format for the JD file is different from the procedures document, and they now want me...