Drawing pictures or shapes can help an individual to enhance the appearance of his presentation. Excel offers various options to draw pictures or anything ...
Alif Bin Hussain
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 ...
Trendlines help an individual to determine the current market price direction. It is important to make decisions about trading products, investing money in ...
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 ...
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 ...
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 ...
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 ...
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 ...
Residential construction estimator is a method of evaluating the potential cost of construction by calculating material quantities and their costs with the ...
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 ...
Symmetric datasets give us normal distribution curves, whereas asymmetric datasets give us skewed normal curves with different shapes of peaks. Asymmetric ...
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 ...
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 ...
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 ...
ComboBoxes and listboxes are useful approaches to controlling the consumer experience by confining the values that a consumer can choose to a predefined list. ...
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.
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 SubHello 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.