How to combine two VBA codes into one avtion?

[jjotc23]

Hi there,
Need helps a lots. I need to combine two vba codes into one action button (Submit). I don’t know any things about this, I need put following:
“

Sub Mail_workbook_Outlook_2()
    Dim wb1 As Workbook
    Dim TempFilePath As String
    Dim TempFileName As String
    Dim FileExtStr As String
    Dim OutApp As Object
    Dim OutMail As Object

    With Application
        .ScreenUpdating = False
        .EnableEvents = False
    End With

    Set wb1 = ActiveWorkbook
…..
……
……
End With
End Sub

”
into

Private Sub CommandButton2_Click()

End Sub

Can anyone help me please? Thanks.

[AndyLitch]

Firstly I recommend you encapsulate your code in hashtags before you get told off ..... Highlight your code and select the hash # on the top menu.

Private Sub CommandButton2_Click()
     Mail_workbook_Outlook_2
End Sub

This will call your email sub from the button on the sheet.

[jjotc23]

Thank you so very much.
JJ

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[AndyLitch]

anytime..........

[arlu1201]

jjotc,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE] before your code and [/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.