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!

Register Log in
  • Congratulations derfloh 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: *

  1. TekiePrincess

    VBSript the gets the latest files then with email files as attachment

    Mrmovie, Multiple recipients - I finally got this to work using the following: Dim ToAddress(2) ToAddress(1) = "xxx@email.com" ToAddress(2) = "xxxx@email.com" newMail.RecipIents.Add(ToAddress(1)) newMail.RecipIents.Add(ToAddress(2)) multiple attachements - The folder that the attachements...
  2. TekiePrincess

    VBSript the gets the latest files then with email files as attachment

    Hi All, I have gotten a little further. This code now sends out the email with the newest file attached but I can not get it to send multiple files or to multiple recipients: Dim fNewest Dim ToAddress Dim FromAddress Dim MessageSubject Dim MessageBody Dim MessageAttachment Dim ol, ns, newMail...
  3. TekiePrincess

    VBSript the gets the latest files then with email files as attachment

    Maybe it will help if I expalin what I am trying to do. I have a folder where daily 2 new files are added to the folder. I am trying to create a script that identifies the latest two files and attach them to an email and send them to multiple people.
  4. TekiePrincess

    VBSript the gets the latest files then with email files as attachment

    Jges, If i just run this portion of the code it works fine. Dim ToAddress (2) Dim FromAddress Dim MessageSubject Dim MessageBody Dim MessageAttachment Dim ol, ns, newMail ToAddress (1) = "xxx@email.com" ToAddress (2) = "xxx@email.com" MessageSubject = "Shipment/Movement Files" MessageBody =...
  5. TekiePrincess

    VBSript the gets the latest files then with email files as attachment

    Guitarzan, I do not get that pop-up windows at all after I added the email portion of the code to my get latest file portion. I check the outbox and nothing is there and no new sent items are there either.
  6. TekiePrincess

    VBSript the gets the latest files then with email files as attachment

    Hi Guitarzan, Yes, I am sure sNewestFile has a value because the following works fine, the popup displays identifying the newestfile name and date last modified: WScript.Echo "Newest file is " & sNewestFile Yes, outlook is installed on the machine. If I test the code with just the outlook...
  7. TekiePrincess

    VBSript the gets the latest files then with email files as attachment

    I have the following script the works without any errors. It just doesn't send the email. Can someone please give me some advice or guidance of where I went wrong. sPath = "C:\Documents and Settings\Desktop\TestFolder\" Set oFSO = CreateObject("Scripting.FileSystemObject") sNewestFile =...
  8. TekiePrincess

    Script to rename, move then execute sql plus for upload

    Annihilannic, PHV and feherke, Thank you all for the help. I have indented the code so that it is easier to read. To answer your question feherke, the loop I was trying to achieve would be from the start of the for loop until the completion of the execution of sql plus. I am wanting to rename...
  9. TekiePrincess

    Script to rename, move then execute sql plus for upload

    Thank you Annihilannic for the feedback I will be sure to do that. I do have one question for my case statement do I need to end the case and if so where would that happen, in the loop or outside the loop?
  10. TekiePrincess

    Script to rename, move then execute sql plus for upload

    I am working on the following script. The original requirement was to just rename the files then move them to a seperate directory. I have the following as my base script and would like to get feedback on how I can make this better or any mistakes I may have overseen as a new shell scripter. #...
  11. TekiePrincess

    Scripting Help

    Hello, I have been asked to expand the script that I have been working on to move the file to a specific directory based on whether the file names contains a particular string: ie; PICK or LOCATOR or SHIP PICK_XXXX_XXXX_XXX LOCATOR_XXXX_XXXX_XXXX SHIP_XXXX_XXXX_XXX I started to try to modify my...
  12. TekiePrincess

    Scripting Help

    Final script... Annihilannic, Your suggestion was very helpful the only change I needed to make was I had to put a space after the number 3 and before I start to identify pattern string and this worked exactly as expected. #! /usr/bin/ksh for f in *.txt; do fn="${f%.*}" l=$(sed -n '3...
  13. TekiePrincess

    Scripting Help

    The suggestions I have received have so far has worked great up to the point where it is using the information on line three of the text file. This was my fault because I think I forgot to mention that this line contains more than just the filename. I have the following script so far: #...
  14. TekiePrincess

    Scripting Help

    Feherke, Thanks this was very helpful. I really appreciate the quick response from both you and stefanwagner. I will be sure to let you know how it turns out. Again Thanks...
  15. TekiePrincess

    Scripting Help

    stefanwagner Thank you so much on helping to get this started to answer your questions: 1a) ororead is a typo, read is meant? Sorry, yes that was a typo. I did mean to say read. 1b) 'the file name, the file' are singulars, so why do we have to loop? I need to loop because there can be more than...
  16. TekiePrincess

    Scripting Help

    I need to create a shell script to perform the following task: 1. Loop through a directory and ororead the file name of the .txt file and save it as a variable. 2. Read the line of that .txt file and from the first " to the last " save that information as a variable. 3. Other processes will be...
  17. TekiePrincess

    Reporting off of two datasources

    Thanks Madawc, I have already defined my excel spreadsheet in crystal and can report off of it. The problem that I am having is how do I get crystal to change the datasource to a different spreadsheet via parameter based off of the excel spreadsheet name or can this not be done. If not what...
  18. TekiePrincess

    Reporting off of two datasources

    I am new to crystal reports and I have been tasked with developing a report that uses two datasources one is an interbase database the other is from an excel spreadsheet. I am trying to figure out how to extract the data from two columns in my excel spreadsheet and pass it to my crystal report...

Part and Inventory Search

Back
Top