Find Jobs
Hire Freelancers

Grab email adresses using a VBA macro from a specific folder in Outlook and feed them to an access database

$2-8 USD / hour

已完成
已发布大约 9 年前

$2-8 USD / hour

Project: Create a VBA macro module to be used in Outlook (Office 2013). The macro code shall automatically start everytime the software is started. The macro code shall pull out all the email adresses in the sent folder and match against 3 access tables (table 1, table 2 and table 3). If the adresses is not found in any of theses 3 access tables the adress shall appear in a pop up window. (10 adresses in the popup window). The user shall then add data for each row containing the email adress. Each row shall contain one new uniqe email adress + the following fileds, country, language, first name, last name, company name. All fields needs to be filled in. Country and language shall be drop down menys based on information stored in access tables (table country and table langage). The user shall also be able to choose a checkbox saying that the emailadress is private or not customer, in that case no information would need to be filled in such as country etc. When all the rows are filled in by the user (max 10 rows) the user can choose to continue with the next 10 rows or to continue the next time the outlook software starts. The data that has been filled in shall be fed to 2 different tables. The "private" "not customer" adresses shall be fed to (table 1) and the rest of the email adresses shall be fed to (table 2). The databases are stored in a server that the user can access only if he/she is located within the network so if no connection is possible the script shall end before trying to connect to the databases.
项目 ID: 7294054

关于此项目

6提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you’d like to build a Macro which can run automatically each time when the Microsoft Access Database starts to add new Email addresses from Sent Items of your Outlook 2013 which are not exist in the existing 3 tables of Microsoft Access Database with some addition details like first name, last name, company etc... I am able to complete all other tasks you described in your project description like the data will store in two different table The "private" "not customer" addresses shall be fed to (table 1) and the rest of the email addresses shall be fed to (table 2). and users will be able to access the database from network, if there is no network connection available the application will display a message that the database is not connected to server and it will stop the further process. I have 6 years experience designing and developing Microsoft Access Application and able to write complected VBA Code. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio.
$5 USD 在10天之内
5.0 (34条评论)
4.9
4.9
6威客以平均价$26 USD/小时来参与此工作竞价
用户头像
Hi Sir. Instead of VB script, I can design a professional .Net add in for you that shall be installed on your outlook. It shall be accessible through top ribbon like other outlook controls and shall carry out the database connectivity as mentioned. I have done similar projects before and I can do this one for you. Instead of an hourly project, I propose to make it a one time project with fixed budget. Please discuss before awarding the project. Regards. Usman
$100 USD 在1天之内
5.0 (28条评论)
6.0
6.0
用户头像
Hi there, I would go with VBA & ADO for database related operations. Please review my profile - I've done several projects involving VBA & Outlook & Access.... Looking forward to hearing from you. Regards,
$33 USD 在3天之内
5.0 (8条评论)
4.8
4.8
用户头像
Proposal belum diberikan
$5 USD 在14天之内
0.0 (0条评论)
0.0
0.0

关于客户

SWEDEN的国旗
Falkenberg, Sweden
5.0
8
付款方式已验证
会员自1月 23, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。