Forum

Hi m r, Attached is a solution using Power Query. I also did one with formulae, different to Purfleet. You can't have too many options. To ext...

🙂

Hi David, Change these p tags to span and insert a br tag between the last 2 lines: .htmlbody = .htmlbody & "<span style=""font-family:ar...

Hi Bill, This is proving to be very difficult to implement. Google results are not in a fixed format. Not only do the results vary by where you a...

You're welcome David.

Hi Nesha, I'm still not sure you are accessing the file(s) as I mean. With the OneDrive app installed on your PC you will be able to access file...

You're welcome.

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...