Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: haedyr
  • Content: Threads
  • Order by date
  1. haedyr

    Including Body in automated email of .xls files

    I have created a macro that I have been using for a few years now, but I never figured out how to add body to the message. I'd like to add body to the emails. I see in the Eudora (yes, I use Eudora) library that there is Body, Bodyastext, etc. I tried adding Body:="blah blah" to the sendemail...
  2. haedyr

    Format & PageSetup changes are not saving with macro

    I have created a formatting macro, which would format what appears to be a .xls file, but is really a text(delimited) file. I'm basically wanting to change pagesetup and autofil the columns. When I run the macro, i can see the autofill changes taking place, but when I go to look at the saved...
  3. haedyr

    Error Trapping Excel Macros

    I have put in an error trap in my code so that if there is an error, that it would skip all code and move to the designated marker. It's not working for me at all. Can somebody please help me figure out what is wrong? Here's the code: On Error GoTo skip_download If labels(indx).email <>...
  4. haedyr

    If statements (Excel)

    I wrote this code to try to minimize the amount of paper I throw away when printing. My purpose is to print 1 page of the active statement if the amount is less than $25. If the amount of the download royalty is 0, then I don't want to print out the download summary sheet. I originally tried the...
  5. haedyr

    Deleting Empty Spaces

    How would I go about deleting the empty space at the top of each page in a document? I'm guessing I can tell it move the cursor until it finds a character, during which time selecting that range. I can then selection.delete...but I'm missing something. Too embarassed to show you my code.... Haedyr
  6. haedyr

    WORD - Inserting Page Break at end of defined text

    I've just started programming and this is my first shot solo. I'm trying to insert a page break at every instance where "Total Amount Payable:" occurs. I've gone to different pages to start the code...but with the code I have now, nothing executes, the cursor just ends up at the end of the doc...

Part and Inventory Search

Back
Top