Write some Software

The automation of merging various PDF's based on a reference number received into an email inbox.

The service in use is;

[url removed, login to view]

Currently after requesting an area from this website, we have to manually search for each utility providers email and combine all attachments manually. We are looking to automate this process through the use of VBA Scripting & Batch Scripting.

Two Resources that are currently being used are;

[url removed, login to view]

[url removed, login to view]

I am looking to modify these existing guides to automatically merge these PDF's in an order based on the utlity type, Gas, Water, Eelectricity etc

More Detail Added, Step by Step Expectation of Software.

1. Using Multiple Reference Numbers provided by user, search and save all email attachments with provided reference numbers.
E.G (Front Cover Attached)
11730979 (General Job Reference) - Front Cover
Note: Most Utilities will have this number in the subject, but not all this is why all utility numbers must be searched.
Utility #1 - 58167608
Utility #2 - 58167604
Utility #3 - 58167609
Utility #4 - 58167607
Utility #5 - 58167605
Utility #6 - 58167606
Note: Number of Utility's Vary
*These emails can have varying file formats, 95% are PDF's but some attachments might be, .ZIP / .TIF or other file formats. If the script cannot handle these formats the user must know so he can manually add them. Same Warning must show for the PDF Merging phase.
Also Note: Utility's might send multiple emails

2. Attachments are Saved onto a Default Network Driver, Folder is Automatically Named as Provided Reference Number
Sub Folders
Either Category name from outlook (such as Gas/Water) or the Reference number of Each utility.

3. Combine and merge all PDF's in Any order, as long as each Utilities PDF's are grouped together.
The Front Cover (Always sent from a specific email) must be at the front.

The more this task can be automated the better, we create hundreds of these packs a month. If you have any idea's on how the above steps can be tweaked please let me know.

This script has to be run at the user's own leisure, after requesting an area it can take between 1-3 days for all emails to be received.

We use a Microsoft Exchange Email system (Hosted by Microsoft) and use the latest 2016 versions of Microsoft office.

We also have a local server running Windows Sever 2012.

Skills: Email Handling, Visual Basic

See more: software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, software write technical manual

About the Employer:
( 1 review ) Melbourne, Australia

Project ID: #12780919

Awarded to:


I currently write software as a full time job using VB.Net. A couple projects included monitoring email using IMAP IDLE as well as parsing those emails. I also have created and combined PDF files. most of what I've use More

$200 AUD in 3 days
(0 Reviews)

8 freelancers are bidding on average $155 for this job


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/b More

$200 AUD in 2 days
(85 Reviews)

Hi, Can we discuss the project in more detail? It seems you like to download PDF attachments from the particular senders and merge them into one final PDF file. IF so, I can provide you an Outlook macro, which wil More

$122 AUD in 2 days
(65 Reviews)

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

$155 AUD in 3 days
(15 Reviews)

Greetings for the day!!! We ensure 100% Quality with ON-time deliveries. Looking forward to hear from you. Thanks & Regards, Team@The24CarrotsInc

$138 AUD in 3 days
(4 Reviews)

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well More

$155 AUD in 3 days
(0 Reviews)

Hi. I am a BEng Engineer with excellent Excel and VBA skills. I am new to Freelancer and thus I don't have a job sore yet - but my services are 100% customer satisfaction guaranteed. I can start on your proj More

$166 AUD in 3 days
(0 Reviews)
$100 AUD in 5 days
(0 Reviews)