Scripting Blog

A place to learn about PowerShell and share stories of automation

How Can I Connect to the Junk Mail Folder in Outlook?

Hey, Scripting Guy! Over the past year or so you’ve answered several questions in which you use a script to connect to the Inbox in Microsoft Outlook. But how can I connect to the Junk Mail folder in Outlook?-- ME Hey, ME. Let’s see, what time is it? OK good: we have enough time to answer this question and get the column posted. We were...

How Can I Use Windows PowerShell to Delete All the .TMP Files on a Drive?

Hey, Scripting Guy! How can I use Windows PowerShell to locate and delete all the .tmp files on a drive?-- OR Hey, OR. You know, there’s an old saying: Give a man a fish and he’ll eat for a day; teach that man to fish and he’ll eat for the rest of his life. Well, unless he’s like the Scripting Guy who writes this column and doesn...

How Can I Print a Microsoft Access Report?

  Hey, Scripting Guy! How can I print a Microsoft Access report?-- RW Hey, RW. You know the cool thing about being a Scripting Guy – aside from the opportunity to pal around with Paris and Nicole – is the fact that people think we know what we’re doing. Someone asks a question like, “How can I print a Microsoft Access report...

How Can I Tell Whether a Number is Even or Odd?

Hey, Scripting Guy! How can I tell whether a number is even or odd?-- JO Hey, JO. You know, just this morning the Scripting Guy who writes this column was driving in to work when he heard an advertisement for a store that sells HD TVs. “We don’t confuse you by stocking all the different HD TVs available,” said the ad. “No, sir. ...

How Can I Split a String Only on Specific Instances of a Character?

Hey, Scripting Guy! I have a series of string values that I need to convert to an array, splitting the value on the ampersand (&). However, if the ampersand is followed by amp (in other words, if the string is &amp) I don’t want to split the string at that point. How do I do that?-- AK Hey, AK. We apologize for taking so long to ...