În desfăşurare

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.


Vezi mai multe: 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

Despre angajator:
( 2 recenzii ) Schaan, Liechtenstein

ID Proiect: #57279

Acordat lui:


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 Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 14 zile
(1 părere)

3 freelanceri licitează în medie 266$ pentru acest proiect


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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 15 zile
(0 recenzii)

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 14 zile
(0 recenzii)