Search results for query: *

Hi Everyone, I've been trying to find a solution for the following example, I send an email to "abc@gmail.com" once sent take the email from the sent folder move to delete folder and permanently delete the item. And this is for email only going to "abc@gmail.com" I've looked around and the...

Sorry I wasnt detailed MTD = Month to date I am calculating the number of records that come back for each month. For example from the query above this is what my output looks like: Month MTD January 671 February 664 March 604 April 599 May 559 and yes I want to keep a running...

Hi Everyone, I am working on a request here and I cant seem to get handle on it. I am create a query that shows both MTD figures but also a YTD column. Here is my query. select case when Month(a.event_date)=1 then 'January' when Month(a.event_date)=2 then 'February'...

Hi Everyone, I'm very new to SAS and i'm running into a problem. I'm doing a proc sql and in it i'm doing a left join. It turns out once quarter my driver table will contain less rows than the right table causing rows to be chopped off I was wondering if this was possible, and what the...

The code worked!! SubString(Right('00000000' + RTrim(acc.custom_data_91), 8), 1, 3) + SubString(Right('00000000' + RTrim(acc.custom_data_91), 8), 6, 3) As ColumnA It wasn't working before because it didnt realize my existing field already had a blank spaces in it, so basically I put the...

Actually this is not working, all its adding is leading 0'z to my columns for for example a column that has 1234567 now becomes, 000000001234567, and when i do a substring a position one for 3 spaces I'm not getting the information I would need? Any suggestions let me know if I need to clarify...

thanks gmmastros for getting back to me i really appreciate, I'm going to test this out on Monday, due to the heavy snow everyone is getting out early :-) I'll let you know monday thanks again,

Hi Everyone, I have the following case statement in my query, and I am looking to see if anyone could give me an idea of how to rework this so I dont get multiple rows in my output Basically I have a field which should ideally be 8 characters in length, then its not I add leading zero's so i...

Hi, I am new to the exchange arena. We just came across a office that used exchange only for sharing their calendars. They want to migrate to a new server and nto lose the ability to share calendars. How difficult is thsi task. The office has around 6-8 clients. can anyone point me to some...

Hi TipGiver, thanks for getting back to me, i used your code and i get teh following: Index was outside the bounds of the array at the following line: r(1).Substring(0,r(1).length-1) please let me know what you think.

Hello Everyone, I trying to get myself familiarized with vb.net. I've done some vba for excel, acess, and some vbscript. I have a file with on the 5th line have to parse out a piece of information. How would i got about this this in vb.net for example file: Line1: Line2: abc Line3: Line4...

VBakias, I really appreicate all your help. I did not get a chance to test this last night, but I'll definitely be testing this tonight. Thanks Again.. Serge

VBakias, Thanks for the hints. I'll give it a try. I hope you don't mind If I have additional questions. Thanks you for the advice. Regards, Serge

Hello Everyone. I am trying to develop an application in either vb.net, vba, vbscript that will basically generate a random alphanumber in the following format xxx-xxxx Letters could be: A-Z (in caps) Numbers coulb be: 0-9 If anyone could please provide some insight, I would really...

Bingo!! Thanks Vongrunt. I appreciate the tip

Hi, I am new to SQL Server, and I know of maintenance plans beign able to backup databases. I currently have some maintenance plans on some of my servers and on others we just rely on the network team beign able to backup all SQL Databases via ArchServe. Well we've been having some problems...

Oh nice!! Less coding for that one ;-) Thanks Again

TomCologne, I was able to find out the answer to this. One has to create a couple for variables but it works fine. One can use the Folders method. The trick with this is that you have to go down the line from Highest hierachy to down to the folder you want to open. I put the code i'm using...

TomCologne, This works perfectly!!! Thanks so much for your help. I really appreciate it. One question. Since I have so many email in my inbox, lets say i made a new folder how would I point to that? This is going to save me so much time. Thanks Again, Sergio

Hello Everyone, I've done some VBA in excel, and access, but this outlook thing is completely new to me. I have a particular folder where I have i woudl say 20-40 emails. All i want to od is export the Mail Subjects, and the Time and Date they were sent, and i guess save to an excel sheet or...