Any VB MS Word Macro writers out there?? $40.00 paypal to anyone who writes one for me.

[PlatinumGold]

I have a macro that i need written. i'm pretty sure it can be done via vb. i have $40 paypal to anyone that can write one for me.

here's what i need.

i have a MS Word document that has a series of Names, Address, Phone Numbers and Fax Numbers.

I want to pull ALL the fax numbers out, i really don't care to associate the fax number with the name yet. mb i'll do that later.

anyway, what i'd like to see done is Find Fax:{space} 12 characters.

i'd like to copy all the fax numbers in a list to either an excel document or a word document (doesn't really matter which).

so, anyone think this is a quick and easy?

 

[dighn]

what's the format like?

just wondering

 

[PlatinumGold]

Name {carriage return}
Address {carriage return}
Phone: xxx-xxx-xxx Fax: xxx-xxx-xxx {Paragraph}

sometimes the fax number is followed by a carriage return instead of paragraph and then you have 2 more lines, email address and web address {paragraph}

 

[gopunk]

if all you need is a list of the fax numbers i can do that for you (albeit without macros). just a little grep here and sed there 🙂

so just copy and paste into a text file... put it on a unix system, grep for all lines with "Fax" in it... take output of that and sed way everything but the fax number

 

[FelixDeCat]

Is this a mailmerge document? How many numbers are in the database?

 

[PlatinumGold]

Originally posted by: gopunk
if all you need is a list of the fax numbers i can do that for you (albeit without macros). just a little grep here and sed there 🙂

so just copy and paste into a text file... put it on a unix system, grep for all lines with "Fax" in it... take output of that and sed way everything but the fax number

i'd prefer a macro so i could use it afterwords as well. 🙂

 

[PlatinumGold]

Originally posted by: FelixDeKat
Is this a mailmerge document? How many numbers are in the database?

nope. straight document. no mailmerge.

i just want to pull out just the fax numbers and put them in a separate list.

 

[gopunk]

Originally posted by: PlatinumGold

Originally posted by: gopunk
if all you need is a list of the fax numbers i can do that for you (albeit without macros). just a little grep here and sed there 🙂

so just copy and paste into a text file... put it on a unix system, grep for all lines with "Fax" in it... take output of that and sed way everything but the fax number

i'd prefer a macro so i could use it afterwords as well. 🙂

what are afterwords?

 

[PlatinumGold]

Originally posted by: gopunk

Originally posted by: PlatinumGold

Originally posted by: gopunk
if all you need is a list of the fax numbers i can do that for you (albeit without macros). just a little grep here and sed there 🙂

so just copy and paste into a text file... put it on a unix system, grep for all lines with "Fax" in it... take output of that and sed way everything but the fax number

i'd prefer a macro so i could use it afterwords as well. 🙂

what are afterwords?

it's called bad spelling after midnight attack.

afterwards, better?

 

[FelixDeCat]

Originally posted by: PlatinumGold

Originally posted by: FelixDeKat
Is this a mailmerge document? How many numbers are in the database?

nope. straight document. no mailmerge.

i just want to pull out just the fax numbers and put them in a separate list.

I started writing macros back in 1990 using the dos version of lotus 123. Back in 2000 we switched over to Word/Excel and just havent quite got the hang of VB Macros (yes I know you CS phds are laughing - but vb for office sucks). Wish I could help, but mail merge for word /excel is my thing.

Good luck.

 

[gopunk]

Originally posted by: PlatinumGold

Originally posted by: gopunk

Originally posted by: PlatinumGold

Originally posted by: gopunk
if all you need is a list of the fax numbers i can do that for you (albeit without macros). just a little grep here and sed there 🙂

so just copy and paste into a text file... put it on a unix system, grep for all lines with "Fax" in it... take output of that and sed way everything but the fax number

i'd prefer a macro so i could use it afterwords as well. 🙂

what are afterwords?

it's called bad spelling after midnight attack.

afterwards, better?

oh haha i thought it was some kind of program... alrighty

 

[KLin]

YGPM 🙂

 

[KLin]

In case anyone is interested, this is what I came up with


macro.doc

Gotta make sure you have a file called faxnumber.xls in c:\

 

[MikeyIs4Dcats]

so does that work for you?