В работе

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.


Показать больше: 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

О работодателе:
( 2 отзыв(-а, -ов) ) Schaan, Liechtenstein

ID проекта: #57279



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 Больше

$299 USD за 14 дней(-я)
(1 отзыв)

3 фрилансеров(-а) готовы выполнить эту работу в среднем за $266


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 Больше

$300 USD за 15 дней(-я)
(0 отзывов(-а))

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

$200 USD за 14 дней(-я)
(0 отзывов(-а))