There are so many files related to that question. Please send me the file that you would like me to work on
Thank you :)
Ok here you go
The formatting is applied to the excel file prior to converting it to html so I am not sure if all the formatting will be retained when saved to an html file.
Here is the formatted excel file "BT Pending.xlsx" prior to converting it to html so you can see how the new macro formats the excel file
Hope this is ok. Let me know if you have any questions
I'll give it a rip. Thank you.
I saw the other 'large job' question is closed. Is there an issue?
Thank you for all your help.
No worries. I can access it, it just says closed. No problem, just checking. :]
No problem. Let me know if the formatting solution that I gave you in my above answer is ok
Hello, unfortunately it does not work at all. Doesn't fit and resize nicely like the table in the email does as per example below. Also no border.
Didn't know that you wanted it formatted in that manner. Also in your last image you only have 4 columns as opposed to the 6 columns we had before
Anyway here is the modified code which formats the file as per you last image
The file will be formatted as shown in the image below
Run time error unfortunately.
The problem is there are some commands that work on the PC version but are not compatible with the Mac, and apparently the 'TextToColumns' command is one of them
Here, I have used an alternative method hope it will work
Please check it and let me know if you still have any issues
I will be working on the other question today
This is what we do at the moment:
Ignore everything after the table as it is me manually doing things.
I don't want to have the email with the xls attached, more I would prefer to cut and paste the pending parts of the two tables into the emails.
I would also like to be able to specify the two email groups from within excel so I could add/subtract email addresses in a separate sheet on the work book and then fire the macro.
It would then set up the email in outlook so it could be quickly scanned over and then I would manually press the send button.
Will review your comments/file and get back to you
Did you have a chance to test the other program?
I ask that you reconsider on three counts:
1. the technical aspect of the issues, from my perspective were the limitations of OSX and IOS.
2. I am quite prepared to pay for failed attempts where I have caused the issue(s), whether it be poor explanations on my behalf or excessive limitations bought on by my situation (ie. attempting to keep everything mac compatible). I understand the 'contractor' situation as I am one also.
3. I feel that this requested solution will work fine now that the limitations have been removed.
4. If/when this solution is successful I would like to implement it elsewhere for reporting and therefore create more work/$ for you, if you are interested.
if the answer is still no, thank you for your help with it, otherwise would really like it if you re-consider the abort.
Thank you again
I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the Professional thinks that someone else might be a better match for your question. I've been working hard to find a new Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.