En curso

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
E.G
\NetworkDrive\DBYD\11730979
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.

Note:
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.

Habilidades: Manejo de email, Visual Basic

Ver más: 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

Información del empleador:
( 1 comentario ) Melbourne, Australia

ID de proyecto: #12780919

Adjudicado a:

Nitro66215

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 Más

$200 AUD en 3 días
(0 comentarios)
0.0

8 los freelancers están ofertando un promedio de $155 para este trabajo.

ineedWorkJob

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 Más

$200 AUD en 2 días
(85 comentarios)
6.1
mrbrave

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 Más

$122 AUD en 2 días
(65 comentarios)
5.6
MohsanEijaz

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 Más

$155 AUD en 3 días
(15 comentarios)
4.4
The24CarrotsInc

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

$138 AUD en 3 días
(4 comentarios)
3.0
asin1987

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 Más

$155 AUD en 3 días
(0 comentarios)
0.0
Quickfixvba

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 Más

$166 AUD en 3 días
(0 comentarios)
0.0
$100 AUD en 5 días
(0 comentarios)
0.0