Posts by bmp1965

Re: Adding UserForm Data into the Body of an Email

Josue2119,
Thanks!!
Bette

Hello!

I'm back for more help! I have written code to generate an Outlook email when the "Submit" button is clicked. The email message opens with the correct email address & subject line, but the body of the email does not populate.
I have attached a representative file of what I'm trying to do.

Thank you in advance for any & all help!
Bette

Re: VBA Excel UserForm "Update" Current Record

jaslake,
You are my hero! Those modifications worked beautifully!
Thank you very much!!
Bette

Hello,

Fairly new at VBA and I'm stuck!
I've created a form where an event can be entered.
I also want the user to be able to update the event, if needed.
I figured out how to search on the event and re-fill the form, but I'm unable to figure out the code to "update" the information when/if changed.
I've been trolling excel boards for days borrowing code and none of it seems to be working.

I've attached a representative example of the file.

Any & all help would be greatly appreciated!
Bette