Hi I'm a bit of a noob so please be gentle. I'm trying to make my life easier with a macro to copy a standard email with a single button. the email is being stored in a sheet with a whole list of email addresses so it would be convenient to just do it all in excel and add whatever codes I want.

My problem though is I keep getting these pesky paragraph marks at the end of a copy and I usually edit this out manually. It still happens when I do something like

```
range("L6").copy

```

so i tried stuff like 

```
dim bla as string
bla = trim(range("L6").value)
bla.copy

```

but I'm finding this doesn't work. I even tried 

```
left(range("L6").copy,len(range("L6").copy)-1).copy

```

but this doesnt work either.

a bit of background for those who care: I have a vendor list with all my vendor information including their email address for bank transfer advisories. in cell "L6" I have a multi-line message that I want to use that reads

Good Morning:

Please find attached copy of bank transfer payment.

Regards,

the message may change so the macro should target this cell. these pesky spaces are so annoying. I add more stuff to the email so its a nuisance to keep copying my standard email message. I even tried looking through the advanced settings of excel - no luck. Im not sure but I think the root of the problem is that the end comma is adding an additional paragraph space at the end of my highlighted text. Any help would be much appreciated. See screenshot for more detail. Thanks

[![screenshot](https://i.stack.imgur.com/j5aWr.png)](https://i.stack.imgur.com/j5aWr.png)

ps. dont know if im using the right tags for best response