Help with Scripting: Excel to SAP then back to excel with data ME23N

[Legacy 296444]

Hello,

New to SAP here and want to make a script to pull data. Never made an SAP script before

I have LOTS of emails (50,000+

) That contain PO #'s.In Outlook i created a VBA macro(With help from online as this was my first vba) to go through the selected emails of my choice and copy that PO number into an excel spreadsheet.


I am looking up the PO's in SAP SSO ME23N to see if they have a green check mark in the release strategy status box. Is there a way i can have SAP Grab the PO's off my spreadsheet, Look them up to see if they have the green check mark, and put that data in Column B of my excel spreadsheet?

I can do the sorting i need from there

All help is greatly appreciated!

 

[Legacy 296444]

This is the code i get when i create a script recording in SAP. Clicking the tab and field i need to check.

If Not IsObject(application) Then
   Set SapGuiAuto  = GetObject("SAPGUI")
   Set application = SapGuiAuto.GetScriptingEngine
End If
If Not IsObject(connection) Then
   Set connection = application.Children(0)
End If
If Not IsObject(session) Then
   Set session    = connection.Children(0)
End If
If IsObject(WScript) Then
   WScript.ConnectObject session,     "on"
   WScript.ConnectObject application, "on"
End If
session.findById("wnd[0]").maximize
session.findById("wnd[0]/usr/subSUB0:SAPLMEGUI:0010/subSUB1:SAPLMEVIEWS:1100/subSUB2:SAPLMEVIEWS:1200/subSUB1:SAPLMEGUI:1102/tabsHEADER_DETAIL/tabpTABHDT12/ssubTABSTRIPCONTROL2SUB:SAPLMERELVI:1100/cntlRELEASE_INFO/shellcont/shell").currentCellColumn = "ICON"