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

[john55]

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

[davesexcel]

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.

Please Login or Register  to view this content.

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

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

[john55]

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.