Access Beginner
Active Member
- Joined
- Nov 8, 2010
- Messages
- 311
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have found some code on the interent which will export all emails from a folder in Outlook into excel.
The issue is that it exports the most important part of the email into one cell. The example below is placed in cell F2. Cell F1 has the heading of "Body".What I'd like if possible, is for a piece of code to be created which will look at cell F2 and create a column for each the field below eg. "Name" in cell G1 as the header and in G2 the value of "Joe", then in H1 create a header called "contactId" and in H2 the value of "xxxxxx" . Cell F3 is in the same format and will have the same number of items (From: Name: etc). So the value of "Name" in cell F3 would be place in G3 and so on.
Hoping someone will be able to assist
Using Excel 2013
Cheers
Haydn
I have found some code on the interent which will export all emails from a folder in Outlook into excel.
The issue is that it exports the most important part of the email into one cell. The example below is placed in cell F2. Cell F1 has the heading of "Body".What I'd like if possible, is for a piece of code to be created which will look at cell F2 and create a column for each the field below eg. "Name" in cell G1 as the header and in G2 the value of "Joe", then in H1 create a header called "contactId" and in H2 the value of "xxxxxx" . Cell F3 is in the same format and will have the same number of items (From: Name: etc). So the value of "Name" in cell F3 would be place in G3 and so on.
Code:
Wiki Data Request:
From: Joe
Name: Joe
contactId: xxxxxx
Contact Number: 99999999
EmailAddress: joe.blow@blahblah.com
Master Program:Test
Division: Test
Branch: Test
Zone: test
Level: Test
Due Date: 2/05/2025
Internal or External: Internal
Request Details: Text text text etc etc
Purpose: Text text text etc etc
Hoping someone will be able to assist
Using Excel 2013
Cheers
Haydn