MuffinMan
10-17-2007, 03:46 AM
Hi,
I am very rookie in VBA ,
I need to make a VBA application that can fetsh some contents in a specific word document and past these contents to specific cells in a worksheet.
the contents are like this :
From: YYYYY
Sent: Wednesday, October 17, 2007 11:55 AM
To:
Cc:
Subject: call info
Caller Informations
First Name: Batman moo
Knew about it from: Newspaper
Product Name: XY
Area: OZ
Mobile Number: xxxxxx
E-Mail address: xxxxxxxx@xxx.com
Comments: bla bla bla
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.14.13/1074 - Release Date: 10/16/2007 2:14 PM
From: YYYYY
Sent:
To:
Cc:
Subject: call info
Caller Informations
First Name: RRR
Knew about it from: ad
Product Name: ZXV
Comments: bla blo bli
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.14.13/1074 - Release Date: 10/16/2007 2:14 PM
....and so on .
I want some of these contents to be pasted into a worksheet table , in a form of table of 7 columns : Name , Knew about it from , Product Name, Area , Mobile Number, E-Mail address, Comments.
Is this doable ?
I am very rookie in VBA ,
I need to make a VBA application that can fetsh some contents in a specific word document and past these contents to specific cells in a worksheet.
the contents are like this :
From: YYYYY
Sent: Wednesday, October 17, 2007 11:55 AM
To:
Cc:
Subject: call info
Caller Informations
First Name: Batman moo
Knew about it from: Newspaper
Product Name: XY
Area: OZ
Mobile Number: xxxxxx
E-Mail address: xxxxxxxx@xxx.com
Comments: bla bla bla
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.14.13/1074 - Release Date: 10/16/2007 2:14 PM
From: YYYYY
Sent:
To:
Cc:
Subject: call info
Caller Informations
First Name: RRR
Knew about it from: ad
Product Name: ZXV
Comments: bla blo bli
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.14.13/1074 - Release Date: 10/16/2007 2:14 PM
....and so on .
I want some of these contents to be pasted into a worksheet table , in a form of table of 7 columns : Name , Knew about it from , Product Name, Area , Mobile Number, E-Mail address, Comments.
Is this doable ?