Hi,
I have below that have "email / name". Is there any way that I can remove the names and the extra space below each email and keep only emails?
Email/NameExpected Resultsa@abc.com / A
b@abc.com / Ba@abc.com
b@abc.coma@abc.com / A
f@abc.com / Fa@abc.com
f@abc.comd@abc.com / D
e@abc.com /...
Hi,
I presently have coding that will allow me to send an email template to multiple recipients based on a cell value in a column. My issue is that I am trying to duplicate the same process for a value in a different column and it the email addresses do not populate in the BCC filed of the...
Hello - I have a spreadsheet where column A is a paragraph of text such as:
sent to: abc@xyx.com
received from: 1234@myco.com
Text here....
or sometimes the cell has contents such as:
sent to: xxx@ourcompanycom received from: xxx@mail.com Hello, I am looking for.. and so on.
Looking for...
ok i have a sheet that looks like this and all i want it to do is this...
<tbody>
frist
date of birth
email
jan.
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec
eric
1/30/1986
eric86vabeach@yahoo.com
*read note*
bob
2/15/1990
bob@bob.com
*read note
</tbody>
ok in cell...
Hello,
I want to send email to list of users which are stored in Excel from A1 to A10.
But if suppose if any of the cells from A1 to A10 is empty then it gives error..
how to take care of empty cells??
Function SendMail()
Dim y As String
y = Sheets(1).Range("A1:A10").Value
' Copy the...
I have a userform with three 2 textboxes, textbox 1 = subject, textbox 2 = body of email and a command button to send the email. I want users to be able to send an email to my email (myemail@email.com) (for reporting problems with workbook).
If I have to I don't have to use a userform. I...
This code works beautifully when there is email addresses in the CC field, but when there is no value in the CC field than an error code 2295 pops up stating unknown message recipient.
I need help with what I think should be a conditional snippet: if Me.CC = " ", then Me.From only else Me.From...
Is there a way to validate more than one email address when entered into an Application.InputBox?
EXAMPLE:
The user can enter just one email address like: test@test.com
or the user can enter multiple email addresses like: test@test.com;test2@test.com
Below is a sweet script I found that will...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.