PDA

View Full Version : VBA, Email sending out from Excel question, please help :)



XstarWake
08-18-2015, 05:48 AM
Hi,

I was able to create a button that send an email out to a particular email from Outlook email.

What i want to accomplish is :

Have a text field that i want to put in the Email_Subject information in there, once entered in the textfield, saved in a value and and i can call that value from my VBA code
Exemple : I have a Dim Email_Subject As String already, but its currently hard coded in the code as : Email_Subject = "Whatever email subject i want"
I want to change the value of Email_Subject with the one ive put in the text field.

Can anyone Help me please?

Thank you for all your help,

XstarWake
08-18-2015, 06:07 AM
Like, can i just do a button, that ask for the subject line text as a pop-up, they i enter what i want, and save that info in a variable, then i call that variable?

XstarWake
08-18-2015, 06:08 AM
If i want to make a button that ask for the subject line, does it need to be a function, not a Sub?

XstarWake
08-18-2015, 06:29 AM
Got it!!!
I got the subject line to work!!!

XstarWake
08-18-2015, 06:57 AM
got it for subject line, email from, who want to get CC or Bcc...

Now i want to set the body of the email but, with only a line, its not going to work. I need to have a bigger field and been able to write multiple lines...

Any suggestion?

XstarWake
08-18-2015, 07:54 AM
no one? like a textarea or something...

XstarWake
08-21-2015, 11:12 AM
lol i guess no one able to help a newbie in VBA hein??