Forum Discussion
Gertdj
Oct 11, 2021Copper Contributor
VBA Copy table from email to Excel - Cannot paste the data - 1004
Hi, I am trying to copy a table from email and paste it into Excel with VBA for further manipulation. I found code on the internet and all seems to work 100%, except the final part where I need to ...
Yea_So
Oct 12, 2021Bronze Contributor
its a good thing I pointed it out, now the real vba affecionados can go at it. vba is not my forte
- GertdjOct 18, 2021Copper ContributorAnyone with a solution or suggestion?
I have now even tried another external forum and still nothing...
Surely someone from Microsoft must be able to assist here?- GertdjOct 18, 2021Copper ContributorHi,
I am running this code on my corporate PC at work and is getting this error.
I have now moved it over to my personal PC and the code is working perfectly.
Could this be a corporate restriction or maybe some setting in Office?- Yea_SoOct 18, 2021Bronze Contributor
I found this link, maybe it will be a stepping stone towards your solution go check it out:
https://social.msdn.microsoft.com/Forums/office/en-US/628d332b-1e1f-48ec-9e73-76c3bd387209/import-data-from-outlook-email-body-into-access
actual vba code:
https://stackoverflow.com/a/40958425/17186635