Paul Gudgeon

VBA code samples

VBA Code samples

This is a snippet of VBA code used to read the Form Definition File (FDF) from a PDF and populate a table with the form fields.

I had to decipher FDF's to do this, which was not in itself difficult.

But Adobe have made SDK part of the commercial package long since and it is a very costly exercise to get the full adobe suite just to read form fields.

Especially since the PDF format is an ISO standard.

Using VBA to supercharge Microsoft Outlook

My language translator button

Our organisation gets enquiries in many languages. Rather than having to copy a message and paste it into an online translator, I have created a macro button which sends the text to an online translator.

This is what it looks look to the user!

And here is the macro that achieves all of that (for those who are interested).

Click on this link to see the macro text

And there is so much more that can be done to supercharge Outlook. Including,

responding to incoming e-mails depending on the shape of the e-mail.
automatically adding details from an email into a CRM dataset.
integrating with a system such as Class for Windows through ADO or an ODBC link

Many e-mail tasks can be automated using VBA and responding to events such as receiving email.