Solution for linking Excel and Outlook

[VBAwful]

Hi Guys,

I have just started a university society and am in charge of most of the admin. As part of this I need to keep track of members details. Currently we have an entry form set up via Weebly(a website building platform) which allows us new members to enter their details and subsequently emails us their details in a ****geneous format.

Previously we have manually entered our members details from these emails into our central database however as our membership grows this has become irksome and time consuming. What we would like to do is find some way that we could tell excel to extract the information from emails in a certain folder and input it into a spread sheet in a macro so that we could update our records at the touch of a button.

Is this possible? If so what methods would we need to use?

Furthermore, if this is not possible then could you suggest any possible solutions to this problem.

Thanks for reading,

Sean

 

[mgm05267]

Hi Sean,

Welcome to the Board...

To collect data from the members which comes through mail, then the best way to use Access.

Use Access External Data, and send the members to fill required fields.

Then, in outlook, a separate folder is created to store those mails from members. Then in Access, you can use manage replies in collect data tab.

This is what I follow in my organisation.

Hope this is helpful for you.

 

[VBAwful]

Thank you so much, that seems perfect for my needs. I didn't realise that Office had that kind of functionality!

 

[mgm05267]

Welcome...
Thanks for feedback...
Glad am of some help for you....