BRIEF OF ISSUE:
MS OFFICE has "linking of database" feature for all versions since 2003. It develop many times with additional features, (Such Smart Tags)
Since MS Office 2010 and upper versions the mentioned linking and smart tag features are not work properly.
If you try linking your MS Access template to any MS Outlook Folder that you will face tables and their fields are not created properly and all of outlook fields are not imported into the columns.
TARGET PROJECT:
We are looking solve issue in following shape and conditions;
1- We would like to have each outlook folder to be linked in separate table in MS Access,
the quantity of Tables, their names to be as same as existed in outlook folder. (If sub-folder exist in ms outlook sub-tables in access, etc...)
Item’s Form view in MS access must be as like as view same in ms outlook with function buttons (Save, Reply, Forward, Flag, Add Task, Delete, whatever operating in Outlook) !
-Inbox
-Sent
-Draft
-Task
-Contacts
-Notes
-Calendar
-Journal
and user folders.
2- Email bodies must be in HTML view in forms but might be embedded as plain text in access table cell,
The key fact: Original email bodies might contain some images, png, gif tables, internet content, mail scripts or macro. Those cause risk and must be avoided in access template!
Thus if any image, macro, script or similar foreign issues out of text containing in the mail, they must be filtered and prompted at the time of import session by prompt user "convert plain text" or "keep html without foreign content" (in this case tables and text format keep) or user might trust to sender and choose "keep whole original".
(if images existed in body of mail instead of attachment, then file in body will be saved as attachment specified in item-3)
3- One of column in access table also will state attachment as hyperlink,
Attachments will be saved in a storage folder while importing with rename string: "sender-receiver [login to view URL]" those keep stored in a folder created by Ms access.
4- Whatever field's existing for an outlook item at the origin properties, they must be also existed in access table by each separate columns without miss any field ("Flag", "importance", "completed" "category"...and others, each outlook item field whatever exist in properties to be converted in columns.)
5- We need table-outlook link to work bi-directional as like as linking mean is that.
Such when we do click to add flag, or click importance in ms access table flag cell or at form flag button, the item will be flagged in outlook too,
(vice-versa)
6- Any interrupt risk must be avoided, Any crush due unexpected reason by PC, RAM, OPERATING SYSTEM, NETWORK, CRUSH of OUTLOOK may harm both database files.
Better to keep original file apart and work on temporary files on each session, recover to back point and backup options must be exist.
We want linking option to be able break out, or keep active by user on click of buttons “ONLINE”, “PAUSE”, “OFFLINE”, which those can be inserted toolbars as Add-ins and data might exchange between database at click on buttons
“which exchange of items will make base on change time for each item separately”!!!...
7-We need "smart tags" function back again in this template,
while it was exist last at outlook 2010 ms access but not updated or existed in current versions of MS Office.
8-THE OS SYSTEM PATCH/HOOK: In addition to the Microsoft smart tag feature (Which this allows user simple visual
coding for many windows/office actions), the freelancer to prepare a ready “expression builder window” for user.
In this Builder Window the user will be able to select his run/result options for an act visually instead of typing syntax for each and save in system files as hook. This builder window must able “save” more than one action either in a single system file or in more than one dll/xml file per action without active run stop another action run.
Best Regards
Hi
I can create the template that will work seamlessly in all MS OFFICE versions starts from 2007 and upper till current MS OFFICE versions. So the template must be able import/export between other access files.
I am well experienced in MS [login to view URL] can have a look over my reviews as well.I will wait for your response to discuss further about it.
Regards
$200 USD in 1 day
4.9 (26 reviews)
5.3
5.3
39 freelancers are bidding on average $115 USD for this job
Hi sir,
I am Lesia who has extensive knowledge and experiences in c/c++/c# programming.
I have enough experience in developing windows desktop app, qt programming, Linux c, embedded device, etc.
I would be happy if we can have a more detailed talk about this project and work together.
Please contact me for further discussion.
Best regards.
Hi,
You will agree with me that the best way to select the right candidate is to see a sample of what Linking database in MS Office will look like. Fortunately, I can complete a part of your job before you award the project.
Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project.
I’d love to discuss more on what would make this project a success for you. Can we have a quick chat?
Thanks for your time
Hi,
I have experience in MS Access, I can help you in creating forms, creating reports, building queries, Creating VBA scripts handling queries, and taking decisions etc.
Kindly send me a message so that we can discuss further regarding the requirements.
I am systems administrator with over 12 years of experience managing server infrastructures and data-center operations across multiple platforms (mostly Microsoft, partially Linux) mostly in virtualized environment (both Hyper-V and VMWARE). Experienced in Web and Email hosting deployment and customer support. Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance. Certified in MCSE 2012, VCP6-DCV and CCNA.
Can we discuss further, so that we can finalise the cost and timeline?
I will be glad to help you.
All is fine, but
1) can you please provide some screen shots for the alignment issue?
2) How many users are expected to use the system? (only one outlook user to one access database)?
3) do you have any kind of automation (e.g. auto reply) in mind using access ?
Kindly find my updated resume attached in my portfolio section.
That being said, I am looking forward to hear back from you.
Good day! I'm an excel, with over a year experience dealing with excel. I've previously worked on the exact same project for another employer.
I look forward to working on this project with you
Relevant Skills and Experience
I've previously worked on the excel project for another company over a year in my country
I’d like to be considered for your writing position. I’m a strategic writer with a strong background developing online content, including blog posts, social media posts, articles, press releases and other branded copy. I can turn a phrase in a way that represents your brand and appeals to your target audience. Whether you need a formal, serious tone or a more playful one, I can make the transition with ease
Development of Custom Websites E-commerce and CMS
I have + 8 years of experience in Development of Custom Websites E-commerce and CMS.
According to your project requirement I just figured out I will be doing it within few days.
Just let me know what is the best way to communicate over the Phone or Chat.
If you have any questions or Query do not hesitate to contact.
Hello, I have 3 years experience of Data Entry, Web Scraping and working on Excel and Word. I will fulfill all your requirements. I am ready to take this project. I assure you that i will deliver this project on time if you give me one chance.
Regards,
Madhav singh
I delevoped many VBA programs to read, write and send mail using Outlook, I developed an Access application that sends thousends e-mail using data from a Crm
I have 11+ years of experience in building MS ACCESS based application. I will be able to deliver this on time. Similar projects has been done in past.
Looking forward receiving positive response from you.
Hi, How are you?
I just reviewed your project description carefully.
I'm very interested in your job now since I have rich experience in these skills.
If you will hire me, I will provide you high quality and deadline.
I hope to discuss more via chat.
Kind regards.