Recent content by gogopoppy

Hi, I'm sending an email message and my code below worked (at home) - the smtp setttings that I used didn't require a secure connection. I tried on different machine (clients) and got the message above. How can I add get this to go away? Set objEmail = CreateObject("CDO.Message") Set...

Thanks I used the link and got an email message. I now have to test it on the real machine Thanks again Grd

Hi, I'm now able to get the information I need (using skipline and skip methods) - I now need to send this info via email. I have outlook on the machine and it is able to send and receive email. I don't have to send through outlook if there is another easier way. Is this complicated? Tx again Grd

make sense and works now a little bit closer... tx

Hi PHV, Thanks for the link. I needed this to get started. Now I have ' VBScript: Trying to open and read a line Dim fso Dim MyFile Set fso = CreateObject("Scripting.FileSystemObject") Set MyFile = fso.OpenTextFile("c:\Logs\testfile.txt", ForReading, True) MyFile.Close I'm trying to use...

Hi, I have a log file generated everyday which is called Log followed by the date 03122009 so the name is Log03122009.txt Its on the same machine where I'm running my code C:\Logs\. On the second line (not at the beginning) I have the following: Record Counts: 333 I would like to open up the...

With the testing I've done it works. The file gets closed if its open. I removed the wscript.echo so it runs unaided. Tx again

Hi, I need to automatically check if an Excel file is open and if it is I want to close and save it or just close it without saving changes. I can do VBA but new to VBScript, so I understand things like Option explicit and Dims. The excel file is on the machine (Win2003 Server) where I would...

Perfecto!! G

Hi there, I have a report which has a list of pay periods for my employees. Its just a list report with no groups. The data looks like this Joe 1/1/2009 JOe 8/1/2009 JOe 15/1/2009 Some pay periods (i.e. certain weeks) are missing and I'd like to have it say missed after the record...

update changing the set datasource properties worked Tx G

Thanks lbass, I'll check this option out.

Hi there, My subreports are all prompting for a db login (to Oracle) despite the fact that both them and the main report are coming from the same database. I'm using Corral Viewer (a free viewer from Groff Automation) to run these reports. They don't prompt in Crystal Designer. Is there...

Thanks everyone These are working (I thought it would be a much harder formula)

Hi there, I've had a request to filter a report by the last month's data but to exclude Mondays! I've tried quite a few things but my formula is not quite working. Could anyone give me a heads up about how to approach this. Its harder than I thought when I said it was possible. Any help or...