No lol's please ha...

I'm a financial services rep with a minor in Computer Science so I got assigned the VB task of creating a new lead to app program to make our biz flow more efficient...

Unfortunately, I haven't used my CS skills since college graduation in 2002 so it was a lot of "on the job learning" on my own...

I came up with exactly what the boss wanted for the interface for the telemarketers... I can even have an email shot off to the underwriter upon the "submit button" command.

What I am having trouble with is including all of the info entered into the fields in the email to the underwriter... I tried to do a screenshot to make it easier on myself but it hasn't worked...

Any thoughts? Here is the interface and the code I employed to attach the screenshot to the emails but it doesn't seem to work . If a screenshot attachment is impossible in 6.5 I guess I can just attach field by field.

The other tweaks I wanted to include was to make sure that all fields were competed prior to the "submit" button working and having the currency and numeric boxes stuck as just that... rather than letting the text boxes be a free-for-all for whatever they feel like entering. I wanted to format the appropriate boxes for rates, numeric values, currency, etc but it's been 10 years and I can't remember???

Any help would be greatly appreciated!!! Thanks!
----------

Private timber As New Timer


Set oWordBasic = CreateObject("Word.Basic")
oWordBasic.SendKeys "%{prtsc}"

timber.Interval = 2000

Shell ("mspaint.exe")

SendKeys ("^n")
SendKeys ("^v")
SendKeys ("^s")
SendKeys "{ENTER}"

Name: mortgage-lead-to-app.JPG Views: 227 Size: 229.7 KB