VBA & Outlook

[joacro]

Any one know where I can get some help with VBA and outlook I wish to create a form in outlook that needs to capture data and with the data entered compile a e-mail message.Regards

 

[VoG]

Start here Mail from Excel and make/mail PDF files (Windows)

 

[joacro]

Isn't there a way that I can create the form in Outlook. I need it to be a mail message and not a attachment

 

[GermanPath]

Isn't there a way that I can create the form in Outlook. I need it to be a mail message and not a attachment

Of course. Create an HTML-body with table and fields and fill this fields in html-structure from your sheet.

 

[joacro]

Where do I start

 

[GermanPath]

You need to read about HTML-coding how to design an table in HTML-code which fulfill your requirement. When you have an proper HTML-code available you can use this as HTML-body for your EXCEL-VBA Outlook procedure. And they defined field-values in this code need to update during runtime of procedure out of your actual cell values.