I tried resync error so I'll reindex and start all over. Thanks
Can you try to use "-zapwallettxes" to remove those unconfirmed transactions or to clear up your core wallet.
You can put that on the bitcoin core shortcut under properties>target put it at the end and then reopen the bitcoin core again.
It should be clear and the amount you sent recently should back to your balances. Now you can create another transaction this time make sure you are connected to the internet before you press the send button.