While dealing with a graph of a curve in Excel, an individual might need to determine the instantaneous slope of any specific point on the curve. This ...
Alif Bin Hussain
Excel can be very helpful in determining remainders. One might need these remainders in Integer or in decimal format. In this article, we will show you how to ...
Sometimes we need to write a large text of multiple lines in Excel. Text boxes are very useful when it is necessary to show a large text in Excel. Moreover, ...
Excel is a very useful tool to do a large number of calculations using mathematical equations. Mathematical equations often include different symbols. One of ...
Sometimes we need to find combinations of various things. Only a few different things can have a large number of combinations. As a result, finding these ...
Checklists are essential for an individual to keep track of tasks already completed and tasks that need to be done yet. Excel can help in creating a checklist ...
Excel can help you shuffle or randomize different formats of data quickly in easy ways. You can shuffle data within one column as well as around different ...
We often need to write different mathematical, chemical, or other types of expressions while presenting data in Excel. Most of the equations have subscripts ...
Using keyboards while working in Excel can increase efficiency and speed. It often saves time and reduces boredom. Changing the font size every time using a ...
An individual might need to print some Excel data on a piece of paper. To do that, Excel worksheets need to be properly aligned to the printing page to get the ...
Sometimes an individual might need to specify some Excel cells to a certain text or number format and limit the number of digits. Data Validation tool can help ...
Microsoft Excel is a very powerful software that is used by people from all around the world. It is a very handy tool that can easily do complicated ...
Tenure refers to the service period of an employee. Employers often need to keep track of the tenure of their employees for various reasons. Excel can help in ...
Zip codes are essential for delivering parcels through postal services to reach a correct destination. Zip codes contain 9 digits, among which the first 5 ...
We often need to show live data or real-time scores in Powerpoint presentations. This type of data changes frequently. Therefore, it is inefficient to change ...
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.