Skip to main content

Send email from Excel with hyperlink function

 Send email from Excel 


    Hi Everyone,

            We are struggling in our day to day life to send bulk email(s). Excel is a ocean where it make the life simpler to send email using simple formula.

            Hyperlink is the formula used, followed by combination of Concatenate (&) symbol.

        &cc=  The CC recipient(s)

        &subject= The email subject text

        &body=  The email body text

         

         =HYPERLINK("mailto:"&A2&"?"

                                    &"cc="&B2

                                    &"&subject="&C2

                                    &"&body="&D2,

                                    "Send Email")

                 


            

            Thanks,

            Gokul Tech Team.



Labels:

Comments

Post a Comment

Popular posts from this blog

Understanding the DATESINPERIOD Function in Power BI

                                              Power BI is a powerful business analytics tool by Microsoft that helps users visualize data and share insights across their organization. One of the key features of Power BI is its ability to handle time-based data with ease, thanks to its robust suite of time intelligence functions. Among these, the DATESINPERIOD function is particularly useful for analyzing data over specific time periods. In this blog post, we'll dive deep into the DATESINPERIOD function, exploring its syntax, usage, and practical applications.  What is the DATESINPERIOD Function?                         The DATESINPERIOD function is a DAX (Data Analysis Expressions) function used to return a table of dates shifted by a specified number of intervals (day...
Post a Comment
Read more

Schema in SQL Database

 What is Schema?                              In a SQL database, Schema is the logical structure. It helps the user to categorize the data according to the nature of information available in that database. For Example: -                             In a factory we have multiple departments are available, details for each department staff collected and maintained in different forms. To categorize them under their working department it will be organized as per the department.                        Similarly, Schema helps user to categorize the data based on the information.  How to Create Schema:                               We can creat...
Post a Comment
Read more

Why to Learn Power BI?

  Introduction to Power BI     Contents:                        - >     What is Power BI?                        ->    Why to Learn?             What is Power BI?                         Power BI is a product launched by Microsoft. It is a Business Intelligence tool which helps us to visualize the data connected from various sources.                      Power B usiness I ntelligence ( BI ) is the acronym for the Power BI. As the name denotes    business intelligence it is used in various analysis purposes in business. It is used from low level             management till the hig...
Post a Comment
Read more