Computer Questions Not Worth Their Own Thread II

I want something with a point-and-click interface. I despise command prompt/command line applications.
 
Linkman226 said:
Might be able to help, but in what format do you have these emails? Saved to your computer? In what format? CSV, XML, or text?

EDIT: I see you mentioned Excel. So it's xls? Can you upload some of these xml files so I can get an idea of format?
Click to expand...

It's 1,160 email messages, all in outlook. Not sure how to save or post that.
 
Hey guys.. I just found a VB script that does exactly what I need! And it works! Here's the script:

Code: 
Sub Extract_Invalid_To_Excel()
 
Dim olApp As Outlook.Application
Dim olExp As Outlook.Explorer
Dim olFolder As Outlook.MAPIFolder
Dim obj As Object
Dim stremBody As String
Dim stremSubject As String
Dim i As Long
Dim x As Long
Dim count As Long
Dim RegEx As Object
Set RegEx = CreateObject("VBScript.RegExp")
Dim xlApp As Object 'Excel.Application
Dim xlwkbk As Object 'Excel.Workbook
Dim xlwksht As Object 'Excel.Worksheet
Dim xlRng As Object 'Excel.Range
 
Set olApp = Outlook.Application
Set olExp = olApp.ActiveExplorer
 
Set olFolder = olExp.CurrentFolder
 
'Open Excel
Set xlApp = GetExcelApp
xlApp.Visible = True
If xlApp Is Nothing Then GoTo ExitProc
 
Set xlwkbk = xlApp.Workbooks.Add
Set xlwksht = xlwkbk.Sheets(1)
Set xlRng = xlwksht.Range("A1")
xlRng.Value = "Bounced email addresses"
 
'Set count of email objects
count = olFolder.Items.count
 
'counter for excel sheet
i = 0
'counter for emails
x = 1
 
For Each obj In olFolder.Items
    xlApp.StatusBar = x & " of " & count & " emails completed"
  stremBody = obj.Body
  stremSubject = obj.Subject
 
    'Check for keywords in email before extracting address
    If checkEmail(stremBody) = True Then
        'MsgBox ("finding email: " & stremBody)
        RegEx.Pattern = "\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b"
        RegEx.IgnoreCase = True
        RegEx.MultiLine = False
        Set olMatches = RegEx.Execute(stremBody)
        For Each match In olMatches
            xlwksht.Cells(i + 2, 1).Value = match
            i = i + 1
        Next match
        'TODO move or mark the email that had the address extracted
    Else
        'To view the items that aren't being parsed uncomment the following line
        'MsgBox (stremBody)
    End If
 
    x = x + 1
Next obj
xlApp.ScreenUpdating = True
MsgBox ("Invalid Email addresses are done being extracted")
 
ExitProc:
Set xlRng = Nothing
Set xlwksht = Nothing
Set xlwkbk = Nothing
Set xlApp = Nothing
Set emItm = Nothing
Set olFolder = Nothing
Set olNS = Nothing
Set olApp = Nothing
End Sub
 
Function GetExcelApp() As Object
' always create new instance
On Error Resume Next
Set GetExcelApp = CreateObject("Excel.Application")
On Error GoTo 0
End Function
 
Function checkEmail(ByVal Body As String) As Boolean
    Dim keywords(25) As String
    keywords(0) = "Error"
    keywords(1) = "user unknown"
    keywords(2) = "The e-mail account does not exist"
    keywords(3) = "undeliverable address"
    keywords(4) = "550 Host unknown"
    keywords(5) = "No such user"
    keywords(6) = "Addressee unknown"
    keywords(7) = "Mailaddress is administratively disabled"
    keywords(8) = "unknown or invalid"
    keywords(9) = "Recipient address rejected"
    keywords(10) = "disabled or discontinued"
    keywords(11) = "Recipient verification failed"
    keywords(12) = "no mailbox here by that name"
    keywords(13) = "This user doesn't have a yahoo.com account"
    keywords(14) = "No mailbox found"
    keywords(15) = "not our customer"
    keywords(16) = "mailbox unavailable"
    keywords(17) = "Mailbox disabled"
    keywords(18) = "mailbox is inactive"
    keywords(19) = "address error"
    keywords(20) = "unknown recipient"
    keywords(21) = "unknown user"
    keywords(22) = "mail to the recipient is not accepted on this system"
    keywords(23) = "no user with that name"
    keywords(24) = "invalid recipient"
 
    'Default value
    checkEmail = False
     For Each word In keywords
        If InStr(1, Body, word, vbTextCompare) > 1 Then
            checkEmail = True
            Exit For
        End If
     Next word
 End Function

just in case anyone is curious
 
This happens to me every once in a while in Chrome. Once it happens I have to close down all Chrome tabs and relaunch it from scratch. I've not been able to figure out another way to stop it from happening.

What happens (and it appears to start randomly) is any non-letter character I press results in the wrong character being displayed on screen. For example, the question mark (?) results in a French looking E with an accent overtop. The ' doesn't work either, neither does the ", or the @. They each give me a totally different character.

Once this starts happening I have to relaunch Chrome. It's really annoying, especially if I have stuff saved in tabs that I left open to get to and take care of later.

Any ideas?
 
Hello, I was looking to upgrade my Inspiron 570 graphics card to an Evga GeForce 430 or an Evga GeForce GTX 550 Ti. I realize that I would most likely have to install a new PSU, so I am thinking of the Corsair Builder 430 watt PSU. I was wondering a) if these components would even work with the Inspiron 570 and b) if they would work, which graphics card would work best with the power supply. (if there are other suggestions, feel free to recommend them, but I'd like it to be fairly cheap).

Thanks in Advance!
 
warpus said:
This happens to me every once in a while in Chrome. Once it happens I have to close down all Chrome tabs and relaunch it from scratch. I've not been able to figure out another way to stop it from happening.

What happens (and it appears to start randomly) is any non-letter character I press results in the wrong character being displayed on screen. For example, the question mark (?) results in a French looking E with an accent overtop. The ' doesn't work either, neither does the ", or the @. They each give me a totally different character.

Once this starts happening I have to relaunch Chrome. It's really annoying, especially if I have stuff saved in tabs that I left open to get to and take care of later.

Any ideas?
Click to expand...

No idea what keys change the keyboard language in Chrome but in Firefox its Left-shift+alt. Might be worth a try
 
Radio Noer said:
Hello, I was looking to upgrade my Inspiron 570 graphics card to an Evga GeForce 430 or an Evga GeForce GTX 550 Ti. I realize that I would most likely have to install a new PSU, so I am thinking of the Corsair Builder 430 watt PSU. I was wondering a) if these components would even work with the Inspiron 570 and b) if they would work, which graphics card would work best with the power supply. (if there are other suggestions, feel free to recommend them, but I'd like it to be fairly cheap).

Thanks in Advance!
Click to expand...

I'll need to know more about your pc, but 430w is hardly going to be enough if you want to plop in a 550 Ti.
 
Well, I am leaning towards the GeFoce 430 anyways, a bit cheaper. I got some help from Dell recently and they said that the components would work in the computer. It's not going to be an amazing gaming rig, but it should at least be able to run most games.

EDIT: I just checked the requirements as stated by Evga and it says just a 400 watt or greater power supply, should the power supply usually be significantly higher than the recommended?
 
No but it has to power your other componants as well remember. Any excess Wattage from the power supply isn't used, so effectively you're paying extra for nothing. This can be handy if you plan to upgrade down the line, however.
 
I see, I guess I'll go with the 430 then unless there's something better out there that can run on 300 watts (so I don't have to get a 500W power supply).
 
I just got a new laptop recently and I want to ask some questions. Firstly though..

FRIENDLY QUACKERS ADVICE:

Make sure your graphics card doesn't melt and simultaneously wreck your motherboard thus causing you to shell out £££ for repairs or a new laptop. :(

Anyways i got a free 2 motnhs mcafee security with my new laptop. When it runs out I intend to use some kind of free software for security. A) Is this ok?, B)If so what should I go for? I need every type of security.
 
Quackers said:
Anyways i got a free 2 motnhs mcafee security with my new laptop. When it runs out I intend to use some kind of free software for security. A) Is this ok?, B)If so what should I go for? I need every type of security.
Click to expand...

A) Yes, assuming it's a laptop for private use, B) MS Security Essenials is comprehensive and free. I recommend that one above all others.

I'm still a fan of Spybot Search & Destroy, but I no longer run it in the background. I'll run a scan about every 2 weeks.
 
Avast! + malwarebytes' antimalware are my choice. :)

I thought about upgrading/building a PC. I want to keep it cheap and upgradable, and this is to what I ended up with my limited knowledge of computers:

Gonna buy:
MoBo with AM3+ slot
Athlon or Phenom 2-core processor (perhaps used)
4 GB ddr3 ram to start with

These I do already have:
power source (I think it's sufficient, but haven't checked yet)
not so good graphics card
IDE HD

Here's some questions:
1. How bad idea it is to use IDE HD? I'm probably buying SATA later, but thought about doing it only when it comes necessary.

2. MoBOs have this information on their compatible processors: "Sempron, Athlon II, Phenom II ( Maximum TDP 140 Watt )". What does this maximum TDP mean? Does it pose a relevant limit? Is 140 significant improvement to 115 watts?

3. PATA=IDE, isn't it?

Here's the MoBo I thought buying, it costs 74.90 euros here.

If there're any local people here, do you know if PC parts are any cheaper in Tallinn?
 
IDE HDDs are OK so long as you aren't using one so old that it will crap out on you. IIRC, the change was to improve data throughput.

TDP refers to the heat that the system can handle. Don't exceed 140 watts, and the heat should be manageable. But if you do, you risk heat damage.
 
I saw a computer for a sale today that had the "IBM" logo on the front of the tower. I was really miffed... I thought they got out of the home PC market over a decade ago?
 
You must log in or register to reply here.

Similar threads

Mesix
Achievements difficult to trigger
Replies
5
Views
266
FluffybunnyMohawk
F
Eyswein
  • Sticky
6otM195 Announcement
Replies
0
Views
503
Eyswein
Eyswein
Nizef
TSG 267 Announcement
Replies
6
Views
887
Rhodro
R
Birdjaguar
Being a Tourist in Italy
9 10 11
Replies
216
Views
5K
Birdjaguar
Birdjaguar
Blake00
CivFanatics attacked, SL unaffected
Replies
2
Views
500
CurtSibling
CurtSibling
Back
Top Bottom