Forum

Hi David, Replace the .Body lines with these .htmlbody = "<p style=""font-family:arial;font-style:italic;font-size:14px;"">Dear Staffs,<...

You're welcome 🙂

Hi PB, As I said in my email, Power Query is the solution here. If you have not used PQ then you will be amazed at what it can do to transform dat...

Hi David, Glad you figured it out. To add that message insert these 3 lines after With OutlookMail .Body = "Dear Staffs," & vbCrLf &...

Hi Nesha, What I was saying is that if you are all using OneDrive then you can access the shared file(s) directly from your PC either using Windows...

Hi David, David: Very strange Vlookup can map some record but when Vlookup error occurs, the macro come to a standstill, What was the pivot table ...

ok thanks. I'm guessing it's a VLOOKUP problem, probably because what it's trying to lookup doesn't exist in the table Managers. How far did the c...

Hi David, Again, need more info please! Why did it stop? Did you get an error? Screenshot? What line of code is highlighted in the debugg...

Hi David, This line .To = WorksheetFunction.VLookup (Range("B2").Value, Worksheets("Staffs").Range("Staffs"), 2) should be .To = Worksheet...

Hi David, Please be specific about the problem. How was it not successful? Did you get a VBA error? If so, please tell me what it was. A scre...

Not sure what you mean, you'll have to be more specific. In the file I supplied, the value entered into B2 gets copied to L2 and then N2 for plotti...

Hi, I don't know if you have dynamic arrays (available in Office 365) so I've written a solution that doesn't use them - see attached. The chart...

Hi Nesha, If you are all running Microsoft 365 (presumably you are all part of the same business tenant?) then you should set up the OneDrive app o...

Hi Bill, Google search results are location specific. The results it gives me when I search here in Australia will most likely be different to wha...

Hi Maria, No file is attached. You need to click the Start Upload button - instructions can be found here Regards Phil