In Progress

VBA Script

Our ERP system is able to interface with MS-Word (2003) and create a Quotation document by filling Text into markers positions. Nowadays almost all communication is going through Email. We therefore want to send the quotations with minimal effort via Email. But we must not send out the WORD document but convert it into a PDF document (we do have Adobe Acrobat 6.0), following certain rules and start a an Email in Outlook 2003 with a certain body test, the said PDF file as an attachment and the Email Address in the To: field.

All names are part of the word document.

Project description.

The sample quote contains the following Text marks. (we use a German version of Word).

1. Create a filename, comprising of the word “ Quotation“+“QuotationNumber[4 digits ]“+„DeliveryName [6 characters]“.

2. Print the document into a temp location using the installed PDF printer. Use the filename of 1.

3. Start a mail message in Outlook.

4. Fill in the field “To:” with “ContactMail”

5. Load the stored PDF file as an attachment.

6. Fill in other fields of the mail message such as topic “eg. NTI quotation No: “Quotation Number”. As body text the mark “Header” shall be used.

7. Do not send the mail off, but stop the script allowing the user to edit and send manually after.


See more: vba adobe, vba with, vba load, system quotation sample, project quote sample, mark fields, it positions, vba adobe api, acrobat distiller api coder, distiller api convert pdf text, vba email word document body, create pdf script outlook security, adobe api vba print word doc pdf, outlook vba word document body, printing outlook email archive pdf file naming script, script word send current document via email, convert textmarks message email, vba stop script, vba outlook delivery time api, adobe vba outlook

About the Employer:
( 2 reviews ) Schaan, Liechtenstein

Project ID: #57279

Awarded to:


I am experienced VBA programmer. As I undestood, You ERP program creates new Word document and shows it to you on screen (like exporting report from Accecc to Excel). If it is so, then you nead the "Magic button" on W More

$299 USD in 14 days
(1 Review)

3 freelancers are bidding on average $266 for this job


Dear Sir, Greetings... I have 6+ year experience in the programing field. Also I have lot of experience with VBA development for creating templates, convertion relevant application. I think I can do it. For your More

$300 USD in 15 days
(0 Reviews)

I beleive I can provide good solution for you involving PDF Distiller (which you said you had).

$200 USD in 14 days
(0 Reviews)