Forum Discussion
EzzEldean
Jun 07, 2022Copper Contributor
Hyperlinks to send email to multiple recipients with multiple CC
Hello Everyone, Thank you for your support in advance My query is just to create a hyperlink to be able to send an email to multiple recipients and multiple CC, So I have come so far with thi...
EzzEldean
Nov 09, 2022Copper Contributor
First of all my apologies for my late reply.
Yes, I am using a macro now
Sub SendEmail_Name of the Macro()
Dim EmailApp As Outlook.Application
Dim Source As String
Set EmailApp = New Outlook.Application
Dim emailitem As Outlook.MailItem
Set emailitem = EmailApp.CreateItem(olMailItem)
emailitem.To = Range("write down the cell").Value
emailitem.CC = Range("write down the cell").Value
emailitem.Subject = "write down the Subject you want"
emailitem.Body = "Dear Team," & vbNewLine & vbNewLine & "Appreciate your support with the below"
emailitem.Display
End Sub
However, I am struggling with an issue, You can't write down multiple cells as if you want to include the values of multiple cells in the range section, For Example, "Range("A1:B1")", If you type this range the Macro will not work when you run it only works with just one cell like this " Range("A1") ", However, The one who can help you the most is HansVogelaar
Yes, I am using a macro now
Sub SendEmail_Name of the Macro()
Dim EmailApp As Outlook.Application
Dim Source As String
Set EmailApp = New Outlook.Application
Dim emailitem As Outlook.MailItem
Set emailitem = EmailApp.CreateItem(olMailItem)
emailitem.To = Range("write down the cell").Value
emailitem.CC = Range("write down the cell").Value
emailitem.Subject = "write down the Subject you want"
emailitem.Body = "Dear Team," & vbNewLine & vbNewLine & "Appreciate your support with the below"
emailitem.Display
End Sub
However, I am struggling with an issue, You can't write down multiple cells as if you want to include the values of multiple cells in the range section, For Example, "Range("A1:B1")", If you type this range the Macro will not work when you run it only works with just one cell like this " Range("A1") ", However, The one who can help you the most is HansVogelaar
Ivana1612
Nov 18, 2022Copper Contributor
Hello EzzEldean
I think the reason is maximum number of characters, in total - calculation all the cells in formula. I have tested and hyperlink is "crashing" on 210 characters and it is working with 209. I googled this and I found some info that 255 characters is maximum, but mine hyperlink was crashing at 210...
I do not know to use macro, but thanks for your reply anyway, it is a sign for me to learn it 🙂
I think the reason is maximum number of characters, in total - calculation all the cells in formula. I have tested and hyperlink is "crashing" on 210 characters and it is working with 209. I googled this and I found some info that 255 characters is maximum, but mine hyperlink was crashing at 210...
I do not know to use macro, but thanks for your reply anyway, it is a sign for me to learn it 🙂
- EzzEldeanNov 19, 2022Copper ContributorAt your service buddy