• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help on userform creating

Natsha

New Member
Hi all

I have to create an userform for productivity purpose... I have added form and labels and text box... Whatever I know but I dnt know how to code it..I referred videos but the code used were different and doesn't work for me... I have attached the excel sheet..

In sheet two j have mentioned the fields format.. after referring it you can delete it.

I also added an commons button for email..
After entering data In the form..I will click the email and it should send an mail in Outlook with the below format.

To: " I can add it
Cc: I can add it
From: my mail

Hi name,

Please find the productivity status for the day

" Productivity status shuld be here with a table or an snap

Signature..


Please help..I been struggling to do this..
 

Attachments

  • Book2.xlsm
    18.9 KB · Views: 6
Like this?
fill the userform and push Submit.
The data will be added an the mailbody will be generated
Then add the email adresses and Pusch Mail
 

Attachments

  • Book2.xlsm
    36.8 KB · Views: 6
"Belleke, post: 279393, member: 34886"]
Like this?
fill the userform and push Submit.
The data will be added an the mailbody will be generated
Then add the email adresses and Pusch Mail
[/QUOTE]


It's was perfect thank you so much belleke...
 
Glad to help and thanks for the feedback.:)

I also have an doubt how to change the font size for the email body msg It's looks small in,I need atleast 11 or 12 font size
Code:

strbody = "Hi," & "<br>" & _

"Please find the productivity status for the day" & "<br/><br>" & RangetoHTML(rng) & "<br/><br>" & "Kind regards," & "<br/>" & L_01.Caption
 
strbody = "<div style=""font-size:16px"">" & _
"<p>Hi," & "</p>" & _
"<p>Please find the productivity status for the day</p>" & _
"<p>" & RangetoHTML(rng) & "</p>" & _
"<p>Kind regards,</p>" & _
"<p>" & L_01.Caption & "</p>" & _
"</div>"

I got this answer from another forum...
 
Natsha
As You've read well from
There are clear sentences about crossposting if someone will use that kind of ...
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
 
Back
Top