Create an MS Access module to email PDFs to the correct contacts

We have a company MS Access database. It includes a contact database of all the companies we do business with.

We need a new module that lets us generate emails to different divisions within those companies: accounting, shipping, contracts. So there should be new tables that track the divisions within the company, and the desired To: Cc: and Bcc: email addresses for that division in that company. It should also include which email addresses from our company to Cc: and Bcc: for each division and who the contact person's name(s) should be (e.g. Dear Mark or Dear Mark/Diana).

This should include a code function that we could use everywhere in the db for generating emails based on the current record.

We also have a feature that generates PDF reports and saves them in our file system.

We need a new function that can look up the PDF that was generated and attach it to the email that gets generated by the program.

For example, when we click "Make contract" it already creates the contract and saves the PDF file. It then launches a new email with the appropriate subject and text, but the To: and CC: are blank and the greeting is Dear XXXX. We want the new function to add the appropriate addresses (To: CC: BCC:) in this case for the Contracts Dept for the customer, address the appropriate person's name (Dear Kimberly) and attach the PDF that was just created.

So, we need a function that we can copy and paste into new sections and new code, with that kind of flexibility, and we want it implemented specifically in the existing Contracts module as a concrete implementation.

Skills: Microsoft Access

See more: we create it, use case module, ms companies, microsoft email for business, includes in use case, create a company email, correct email address, contract accounting pdf, contact us module, concrete use case, access database module, email g, need an accounting person, accounting email address, ms access email, ms access 2013, microsoft access for business, kimberly, diana, copy pdf text access, accounting program example, greeting company, generate code database record, create access database reports, add pdf email

About the Employer:
( 8 reviews ) Costa Mesa, United States

Project ID: #4641726

Awarded to:


Simply put, I have well over twenty-five years of experience working with relational database applications and Microsoft Office products such as Access, Outlook, SQL Server and Excel. In fact, less than a hour ago I d More

$175 USD in 2 days
(5 Reviews)

20 freelancers are bidding on average $203 for this job


Hi, I see your needs and i want to help.

$155 USD in 3 days
(30 Reviews)

20 years experience in Access and VBA experience - please see PMB

$155 USD in 3 days
(7 Reviews)

Hi, I have experience with this project, I happily if work with you in this project. Best Regards winnet21

$200 USD in 5 days
(11 Reviews)

Looks rather like fixing existing code and extracting it into separate function. Can do.

$250 USD in 3 days
(3 Reviews)

Hi! Let me help you with this interesting project.

$277 USD in 10 days
(23 Reviews)

I can develop this email app.

$147 USD in 3 days
(13 Reviews)

Looking forward to working with you ...

$198 USD in 3 days
(1 Review)

Please, See my private Message.

$263 USD in 7 days
(2 Reviews)

Hi, I am interesting on this small task. Please refer Inbox for more details.

$111 USD in 3 days
(1 Review)

I have made an access database that does this exact function. Navigating pdf files, and attaching them to corresponding emails. I can make this very nice, modern and fluid. We can add various functionality like variabl More

$333 USD in 3 days
(0 Reviews)

I have designed and implemented over a 100 MS Access Databases for different clients over the last 10 years. I have created such a module before and can assure you that I can do so for you. I would be happy to emai More

$250 USD in 3 days
(0 Reviews)

Dear Hiring Manager, I am working in IT sector for last 12 years starting from Junior Programmer-Senior Programmer-Tech Lead-System Analyst and [login to view URL] my technical skills and deliverable or technical sup More

$250 USD in 7 days
(0 Reviews)

Hi, I have large experience with Access applications, If you like I can send an example for you. I have full time availability Some companies using my applications. Wait for mo More

$133 USD in 4 days
(1 Review)

Very strong Ms Access Skills and PDF generation experience using GhostScript.

$155 USD in 3 days
(0 Reviews)

I have experience of 6 years in Access. Please give me this task. Thanks

$155 USD in 2 days
(0 Reviews)

Hello, I can develop your application on your requirements. Freelance With 10 Years Of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public Or Private Sector.

$233 USD in 3 days
(0 Reviews)

I have more than 15 years of MS Access development experience. I may something already that can be very easily adopted for your needs. I have extensive experince in integrating different PDF writers/Drivers into MS Acc More

$244 USD in 3 days
(0 Reviews)

pleae check you pm.

$224 USD in 4 days
(0 Reviews)

Hello, I am a Microsoft Access Developer.. I write Accounting software for a living. Read my PM message and we can discuss further.

$155 USD in 3 days
(0 Reviews)