Search results for query: *

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

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

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.

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

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.

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

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

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

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?

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

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

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

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

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

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

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

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

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