Well I put the following code in my send email button

With Destwb.Sheets(1).UsedRange
.Cells.Copy
.Cells.PasteSpecial xlPasteValues
.Cells(1).Select
End With
Application.CutCopyMode = False

just paste everything and that made the connections to go away. Kinda
like what Michael told me.

Thanks.