Forum Moderators: open

Message Too Old, No Replies

Emailing Word Form Content

using VBScript to email the contents of word form fields

         

MandyM

1:30 pm on Jan 23, 2006 (gmt 0)



I have set up a MS Word form that the user fills in and prints as an Invoice Document - I then want them to be able to email me the contents of the form fields (each field on a separate line finished with a ;) so that this can be used to automatically post a transaction into the Accounts package.

The To Address needs to be hard coded into the email and I don't want any of the formatting i.e. boxes, text etc.

Any help gratefully received!

aspdaddy

6:24 pm on Jan 23, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi yes it can be done with a vba macro in the Word template.

The actual code depends on how your word doc is set up and what email package your users have installed.

With tables you access the documents data by table, row and cell number, building your email and then automate the mail package. Assign the macro to the document print event so they cant forget to do it.