Forum Discussion
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...
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
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 🙂
- At your service buddy