Find last cell in column, add it to a specific cell and ...create e-mail

Hello,

I'm facing with an issue, it's an issue because I have no idea how can be done...
I save the Sheet2 as .cvs and then I create an e-mail. This is ok!
Before to save it as .csv, I need to find the last cell with value in column J (did it with a formula) and place it near to the text of J2. I mean cell J2 has "Record Nmbrs" text and add the value from the last cell.
I tried some workarounds, I thought that I fixed it but the content of e-mail ....has 3 or 4 commas after each row (i.e Record Nmbrs 5,,,) which is not ok!
Can you help me, please?

Thank you
Regards, George

Saving a .csv will save all columns in the sheet, since 5 is in several columns over, the comma separator will include those blank cells.

If you are just using .csv so you have something to paste onto the outlook email, you can paste the specific range in excel.

Check it out.

Sub CopyRngToOutlook()
    Dim doc As Object
    Dim LstRw As Long
    Dim rng As Range, rng2 As Range, st As String, x
    Dim sh As Worksheet
    Set sh = Sheets("Sheet2")
    With sh
        LstRw = .ListObjects("Table13").Range.Columns(1).Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
        Set rng = .Range("A2:J" & LstRw)
        st = "Total Records - " & .Range("J" & LstRw).Value
    End With


    x = Len(st)
    With CreateObject("Outlook.Application").CreateItem(0)
        .Display
        .body = st
        Set doc = .GetInspector.WordEditor
        
        rng.Copy
        doc.Range(x, x).Paste


        .To = "someone@somewhere.com"
        .Subject = "Send Email Body"
        Application.CutCopyMode = 0
    End With
    
End Sub

Once you have formatted your cells it will end up like this:
------------------------------------------------------------------------------

2022-12-25_5-34-19.jpg

Hi Dave,
Thanks a lot for your support!
It doesn't help me, I need to have it in notepad format because I sent it to an MQ and this is the exact format it ingests... I've just tried not to type manually the last value from column J into email body in J2...
Again, thank you very much.