Abrar-ur-Rahman Niloy

Hello Richard!

You need to replace 0s in the format type with 0.00s.
For example, instead of #,##0_) ;(#,##0) for center alignment, use #,##0.00_) ;(#,##0.00).

Regards
Niloy
Team Exceldemy

Hello again, Jessica! In the previous reply, I have mentioned exactly how you can do this. If you go through the second step, you will find the item number of your second Outlook mail (generally is 2. can also be 1 depending on how you had logged in to your accounts).
If it isn’t, take note of the number. Replace the 2 in .SendUsingAccount = mApp.Session.Accounts(2) with the number Excel shows. You will find this line in the With statement at the end.
In case if you are having trouble understanding any of the part, let us know about that.

Hi, Jessica!

Yes, it is possible. In short, Outlook assigns every email of yours to a number. You can call a specific mail using the Accounts.Item(x) method, x is the number assigned to the mail. Mention this account in the MailItem.SendUsingAccount property and the code will send the mail from that specific account. Keep in mind, the process works for Excel 2007 and later versions.

Here is the details of the process:

1. First, check the Microsoft Outlook 15.0 Object Library in VBA editor from the Tools>References>Available References.
   (This is to enable the Outlook library in your Excel workbook)
2. If you want to find out the numbers associated with each mail, use a code utilizing the Accounts.Item method like the following.

   Sub EmailAccountsList()
   
       Dim OutMail As Outlook.Application
       Dim i As Long
       Dim MailRow As Long
       MailRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
     
       Set OutMail = CreateObject("Outlook.Application")
   
       For i = 1 To OutMail.Session.Accounts.Count
           Sheet1.Cells(MailRow, 1) = OutMail.Session.Accounts.Item(i)
           Sheet1.Cells(MailRow, 2) = i
           MailRow = MailRow + 1
       Next i
   
   End Sub

   This code will give you the list containing your outlook mails and their numbers on your spreadsheet.

3. Now, use this number in the SendUsingAccount property. Take the first code in this article, for example. In the With statement of mMail, you can modify it like this:

   
   Sub ExcelToOutlookSR()
   Dim mApp As Object
   Dim mMail As Object
   Dim SendToMail As String
   Dim MailSubject As String
   Dim mMailBody As String
   For Each r In Selection
       SendToMail = Range("C" & r.Row)
       MailSubject = Range("F" & r.Row)
       mMailBody = Range("G" & r.Row)
   Set mApp = CreateObject("Outlook.Application")
   Set mMail = mApp.CreateItem(0)
   With mMail
       .To = SendToMail
       .Subject = MailSubject
       .Body = mMailBody
       .SendUsingAccount = mApp.Session.Accounts(2)   'Replace the number in the bracket with your mail number from the previous code's list
       End With
   Next r
   End Sub
   

Hope this helped. If you still have inquiries, let us know.

Hi Nawaf, thanks for the appreciation!

We focused more on the checklist side of the task tracker- whether or not the task is done or yet to be done (or not) was our main focus here. Also, we wanted to rearrange and prioritize our tasks based on a criteria. So we skipped the timestamps in this article. If that is your priority, you can easily do so too by adding an extra column and including it within the dataset too.
You can also add an assigned time and current time and compare them to find the status of the task in the main dataset. If you face any problem regarding the timestamps or want to do something particular with them, let us know. We are always here to assist.

Thank you for pointing this out. There are some cache files in the location and the article has been updated for later uses.

Hi Elly,

For your data, plotting a stacked bar chart would not be possible. Excel needs a dataset of the following sort to plot a stacked bar chart.

1st Week 2nd Week 3rd Week 4th Week
1st Task 44 41 61 58
2nd Task 38 52 53 64
3rd Task 42 48 50 56
4th Task 37 59 44 46

Even in that case, creating a Gantt chart would not be appropriate, as one bar will start where the previous one ended. This will ultimately result in the same bar plot. But if you have a gap between each work period, you can put them in between these values and follow the steps of the article.

Glad that it was helpful to you, Troy. Stay with us for more of these stuffs in the future.

Sorry for the inconvenience. It has been fixed.

Hi Kheiy. Yes, there is an easy way to do that. Go to the Mailings tab on the word file and select Finish & Merge. Then select Print Documents from the drop-down. After that, you can find the option to print all pages or a particular range if you want.

Glad it had been helpful for you.

Click on “Enable Editing” in the message that appears above the formula box.

We are glad that this helped.

Hi Colvis.

We are very sorry for not reaching out to you promptly. But the annual IRR is calculated by multiplying the monthly IRR by 12. In that case, we get an annual IRR value of 6.504%. The value of IRR from the IRR formula and the XIRR formula should not be the same for irregular cash flows. And these values reflect that.

Hi SteelWolf,

I am not sure what you meant exactly by that. But assuming you want to put in a date in cells F6, H6, J6, L6, N6, P6, and R6 that match with cell J1, you can use formulas in those cells with reference to cell J1. For example, let’s assume you want the previous date, exact date, and the following date of cell J1 in cells F6, H6, and J6.
You can write =J6 in cell H6. Write =EDATE(J6,-1) in cell F6 and =EDATE(J6,1) in J6.

You can modify/ use different formula according to your needs in this way.
But if you want you use the “autofill” in those scattering cells, it is not possible yet as of the latest version of Excel.

Hope that helps. If you meant something else entirely, please let us know.

Hi Elona,

I am not sure I understand your problem quite clearly. But if you are having problems importing data from different sheets, then put the sheet name before the range in single quotes followed by an exclamation sign.

For example, you should add ‘Sheet 2’! before the range G3:G123 or any other range while using them as the source to use formulas in the first sheet.

hi Willy,

Make sure the file names are correctly spelled in the line. Check if both the source file and target file name are correct as well as if the directory of the workbook file is correct too.

If the problem still persists, please provide us with a bit of more information, like what is the error message or perhaps a screenshot.

Hi Jeff, so sorry for your unfortunate situation. But the formulas are structured in such ways that it returns empty strings if only certain criteria are met. It won’t result in entire rows or columns being empty.

Hi Esayas,

You can count that if you mix the formulas with the COUNTIF function. You have to be a bit creative while using it in VBAs. For example, take the first method. You can use =TEXTJOIN(“, “,TRUE,IF(C14=B5:B12,C5:C12&”:”&COUNTIF(C5:C12,IF(B5:B12=C14,C5:C12)),””)) formula instead of the given one to find the count of each one in the dataset along with the models.

Hi Jose,

You can choose any of the three methods given above to remove the “↑” sign. All of them work for any non-numeric character, including the one you are asking.
Hope that helped. If you are still facing problems, let us know.