drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!!
I am taking info from a Folder (just the .MSG extension files) (No problem)
From those files I need the:
now the msg.body always keeps the same format and as follows:
2/4 lines and then
I would like to get the blue INFO this info, I mean:
InStr to find where is located NAME, Phone, E-mail... and son on and then Mid(...)
Is there any easyer way?
because the Info I need has 15 mandatory fields in 20 rows and my way is not nice
I am taking info from a Folder (just the .MSG extension files) (No problem)
From those files I need the:
- msg.SentOn
- msg.to
- msg.cc
- msg.bcc
now the msg.body always keeps the same format and as follows:
2/4 lines and then
Name: | Mike Tyson |
Phone: | 123456789 |
E-mail: | aaaaa@ggggg.com |
How did you hear about us? | TEXT |
DATE: | 12/09/2020 |
TIME:: | dinner: 21:00 - 23:00 |
Diners: | 4 |
Comments: | TEXT |
I would like to get the blue INFO this info, I mean:
- Mike Tyson
- 123456789
- aaaaa@ggggg.com
- TEXT
- 12/09/2020
- Para Cenar: 21:00 - 23:00
- 4
InStr to find where is located NAME, Phone, E-mail... and son on and then Mid(...)
Is there any easyer way?
because the Info I need has 15 mandatory fields in 20 rows and my way is not nice