Search results for query: *

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...

It worked! I could kiss you right now!!!! Thank you sooooo much. Something as simple as that...go figure. You rock the house. Thanks again, Haedyr :D

Hi Skip, that's where I think my problem is. here's the scenario: if I right click on the original "workbook", properties show me it is a .xls file. However, when I open the file, make changes to the file, and then hit save, Excel tries to save it in .txt format. So, I believe the file is a...

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...

I actually have another problem. I'm emailing these.txt files using the Macro. I'm using Excel 2000 and Eudora 6.2. When the person receives the .txt files, they aren't able to import them into excel like they used to when I didn't use the macro to send the files. I was thinking that the reason...

it worked!! Thank you very much. :)

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 <>...

I wanted to tell you I figured it out. I needed to load the value of the cells amount_due and total_download_royalty. Therefore, I used if range("amount_due").value > 25 then Thanks for all your help.... Haedyr

ck1999 - thank you for your tip. I did originally try the code you suggested to no avail. When using this code, statements that are < 25 only print once (and the total download = 0). That seems to work fine. But, when it's > 25 only one copy prints out. and if the total download > 0 the download...

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...

I was wondering...is there the Trim() function in Word? Is that even a worthy option? And, yes the white blank lines vary for each page...but I need to rethink this because I could solve this problem very easily by creating a new document at each instance of a manual page break, then I wouldn't...

Yes - this is a report generated out of a database program. It is normally copied and pasted into word...but I've just finally got my hands on it and have, for the time being, saved it as a .txt file. Since Excel is easier for me to program in (I don't know nearly as much about Word as I do...

Hi Gerry - I'm trying to delete all the empty lines leading up to the text "Date Generated". Since I couldn't figure out how to do that with code, I decided to take the easiest approach I could think of which is set the cursor at the beginning of the text, and hit backspace a few times. I don't...

I don't understand quite what you mean. This is the code I created. Basically finding a certain text, trying to get the cursor to start at the begining of the text line and then back spacing 3 lines to start at the top of the page. Selection.HomeKey (wdStory) Do Until...

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

Thank you Tony. I appreciate your thoroughness when responding to my questions.

Wonderful!!! It worked. Thank you Tony. Here's what it ended up looking like in case you are curious. I do have a question as to why I need to clear formatting? What exactly does that do? Public Sub Page_Breaks() Selection.HomeKey (wdStory) Do Until ActiveDocument.Bookmarks("\Sel") =...

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...