User Posts: Alif Bin Hussain
0

## How to Draw Pictures in Excel (3 Easy Ways)

Drawing pictures or shapes can help an individual to enhance the appearance of his presentation. Excel offers various options to draw pictures or anything ...

0

## How to Calculate VaR Using Delta-Normal Method in Excel

Looking for a way to calculate VaR using the Delta-Normal method in Excel? Well, you have come to the right place. In this article, we will walk you through ...

0

## How to Visualize Trends in Excel (3 Effective Ways)

Trendlines help an individual to determine the current market price direction. It is important to make decisions about trading products, investing money in ...

0

## How to Calculate Daily Volatility in Excel (2 Easy Ways)

Volatility is the speed and magnitude of the fluctuations of the price of a specific time period. The price of an asset or a commodity might change every day ...

0

## How to Use VBA Dictionary in Excel (6 Practical Examples)

The VBA dictionary is a useful tool for storing various types of data and easily using them with a single variable. This is why learning the VBA dictionary can ...

0

## How to Create a Rating Scale in Excel (4 Easy Ways)

Rating scales are used to evaluate responders' feedback towards a particular product. Excel can help greatly in creating a rating scale for any number of ...

0

## How to Create Mortgage Loan Pipeline Management in Excel

If you need to keep track of mortgage loan status, Excel can help you greatly. In Excel, you can easily create a table of the various stages and regularly ...

0

## How to Navigate Large Excel Spreadsheets (10 Useful Techniques)

Sometimes we work with a large amount of data in Excel. Keeping track of this much data is often very difficult. In this article, we will show you how to ...

0

## How to Calculate Residential Construction Cost Estimator in Excel

Residential construction estimator is a method of evaluating the potential cost of construction by calculating material quantities and their costs with the ...

0

## How to Overline Text in Excel (4 Easy Ways)

One might need to put a line over text for various purposes. For instance, Means and Vectors are expressed by putting a bar on the top of a text in ...

0

## How to Create Graph of Skewness and Kurtosis in Excel

Symmetric datasets give us normal distribution curves, whereas asymmetric datasets give us skewed normal curves with different shapes of peaks. Asymmetric ...

0

## How to Create Drill Down in Excel (with Easy Steps)

While working with a large amount of data, one might need to filter only a fraction of the whole data for various purposes. Excel can be a very useful tool for ...

0

## How to Display Tooltip on Mouseover Using VBA in Excel

Sometimes you might want to know information before clicking on anything in Excel. You can do it by adding a tooltip to a text, shape, and image that will be ...

0

## How to Circle Text in Excel (3 Easy Ways)

Sometimes you might need to enclose a text inside a circle to highlight it or for some other purpose while working on Excel. You can do this easily and quickly ...

0

## How to Select First Item from ComboBox Using VBA in Excel

ComboBoxes and listboxes are useful approaches to controlling the consumer experience by confining the values that a consumer can choose to a predefined list. ...

Browsing All Comments By: Alif Bin Hussain
1. Reply
Alif Bin Hussain Mar 9, 2023 at 5:38 PM

Hello SANJAY DANGI,

Thank you for reaching out. You can add attachment to the email in the first method easily. Follow these steps to do it.

• In this example, we want to attach a file named Attachment.pdf.Â The path directory for the file is D:\Exceldemy\.

• First, download the workbook provided in this article and open it.
• Next, add a new column (H) and write the file names you want to attach to the email. Make sure to write the file extension.

• Then, open the code module and write the following code.

```Sub ExcelToOutlookSR() Dim mApp As Object Dim mMail As Object Dim SendToMail As String Dim MailSubject As String Dim MailBody As String Dim FileName As String Dim Path As String 'Declare variable for file path Path = "D:\Exceldemy\" 'Set file path For Each r In Selection SendToMail = Range("C" & r.Row) MailSubject = Range("F" & r.Row) MailBody = Range("G" & r.Row) FileName = Range("H" & r.Row) 'Get file name from H column Set mApp = CreateObject("Outlook.Application") Set mMail = mApp.CreateItem(0) With mMail .To = SendToMail .Subject = MailSubject .Body = MailBody .Display .Attachments.Add (Path & FileName) 'Add attachment End With Next r Set mMail = Nothing Set mApp = Nothing End Sub```

• After writing this code, go back to the excel sheet.
• Then, select one or more names and click on the button.

• As a result, Microsoft Outlook software will open and you will find the email already written with the attached file. You can just click send to send the Email.

2. Hello Theo,

Follow these steps to adjust ranges to make a longer list without any error.

1. First, to make the task list longer, select cells H13 through J13. Then drag the fill handle down to add new task.

2. In this example, we added five new tasks. Therefore, the new ranges for column H, I and J are H6:H18, I6:I18 and J6:J18 respectively.

3. Then select cell D6 and change the ranges of H,I and J cells in the formula bar and press Enter. After that, Autofill formula up to cell D9.

4. Similarly, change the formula ranges for other cells as well.

5. Finally, you can see in the following figure that the formula is working properly.

I hope this solves your problem. Please let us know if you face any other issues.

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS