TrippyTom
12-01-2005, 01:23 PM
Hi everyone,
I have made a "template" in word that has a basic format with tables to show a Working Group List (call list with addresses and phone numbers). Currently, I paste/special as text from whatever source I'm getting the data from (Excel, website, another Word doc, etc). What I would like to do is somehow automate this.
I think I will need vba for this because it's more advanced than just using a style. Certain words need to go into cells in a table. For instance:
The basic layout of a table would be 3 columns:
Name & Title go into the left cell
Tel, Fax, email go into the middle cell
Any home info goes into the right cell (Address, Tel, Cell, email)
Would it be worth trying to VBA this process? Or am I just wishing for too much?
I have made a "template" in word that has a basic format with tables to show a Working Group List (call list with addresses and phone numbers). Currently, I paste/special as text from whatever source I'm getting the data from (Excel, website, another Word doc, etc). What I would like to do is somehow automate this.
I think I will need vba for this because it's more advanced than just using a style. Certain words need to go into cells in a table. For instance:
The basic layout of a table would be 3 columns:
Name & Title go into the left cell
Tel, Fax, email go into the middle cell
Any home info goes into the right cell (Address, Tel, Cell, email)
Would it be worth trying to VBA this process? Or am I just wishing for too much?