How do get Outlook Responses to Update Excel Spreadsheet

Down_Under

New Member
Joined
Aug 9, 2013
Messages
10
Hi, I am trying to use a spreadsheet to track responses that I receiving via Outlook. The responses are confidential, so I can't have the spreadsheet shared for users to update. What would be the best way to have the responses entered into the spreadsheet, without it being overly manual? My initial thought was using the voting buttons, then copying from the tracking page, but each user will have a different response.

Thank you for your help.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hi

This code extracts information from items in an Outlook folder:


Code:
' Excel module
Sub GetFromInbox()
Dim olapp As Outlook.Application, olNS As Namespace, Fldr As MAPIFolder, _
olMail As Object, i%, ts As Worksheet
Set ts = Sheets("test")                                 ' where to paste info
Set olapp = New Outlook.Application
Set olNS = olapp.GetNamespace("MAPI")
Set Fldr = olNS.GetDefaultFolder(olFolderInbox)         ' desired folder
i = 1
For Each olMail In Fldr.Items
    If TypeOf olMail Is MailItem Then                   ' only mail items
        i = i + 1
        ts.Cells(i, 1) = olMail.Subject
        ts.Cells(i, 2) = olMail.SenderName
        ts.Cells(i, 3) = olMail.Body
        ts.Cells(i, 4) = olMail.ReceivedTime
    End If
Next
Set Fldr = Nothing
Set olNS = Nothing
Set olapp = Nothing
End Sub
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top