Find Jobs
Hire Freelancers

MS Access populate excel and email, then Import from outlook

$30-90 USD

Completed
Posted over 14 years ago

$30-90 USD

Paid on delivery
Hi, I have an access database containing a member table. What I would like to do is populate the excel template (attached) with the members info from this database and email it to each members email address as an attachment. (will need to loop through all members in the database) The member who receives this email will then update any information (excluding the member ID) in the excel file and send it back (the email will contain the text somewhere in the subject 'Member Update'. What I would like to then do is import the data from the email attachment received, back into the database (using the locked member id in the excel file as the identifier to match up in the database). I have done a bit of work extracting data from outlook before but haven't gone down the path of extracting data from the attachment in the email. I have included a sample database containing the member table and a form which opens up outlook and loops through and finds any emails with the desired subject to import. I have also included the excel template which I would like to populate and import (would prefer if the sheet was locked with only the fields in white to be editable).
Project ID: 2886560

About the project

14 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$59.50 USD in 7 days
5.0 (592 reviews)
7.4
7.4
14 freelancers are bidding on average $63 USD for this job
User Avatar
See private message.
$76.50 USD in 7 days
5.0 (723 reviews)
7.5
7.5
User Avatar
See private message.
$76.50 USD in 7 days
5.0 (151 reviews)
6.3
6.3
User Avatar
See private message.
$76.50 USD in 7 days
4.7 (65 reviews)
4.9
4.9
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (49 reviews)
4.7
4.7
User Avatar
See private message.
$76.50 USD in 7 days
4.7 (27 reviews)
4.5
4.5
User Avatar
See private message.
$51 USD in 7 days
4.9 (20 reviews)
3.2
3.2
User Avatar
See private message.
$76.50 USD in 7 days
5.0 (7 reviews)
2.0
2.0
User Avatar
See private message.
$76.50 USD in 7 days
4.0 (1 review)
1.9
1.9
User Avatar
See private message.
$42.50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (1 review)
0.0
0.0
User Avatar
See private message.
$68 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$51 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$72.25 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
8
Member since Oct 24, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.