We have a customer database in excel appprox 3000 names and addresses they all have a unique customer number in column "A". We write a individual letter to about 50 of these people each week when they contact us. At the moment we write the letter, swap to the spread sheet, copy and paste the data into word. I have tried to automate this using VBA but without any success.
I can check if running and start excel if needed from word
In excel I can search for the ID number, select and copy the relevant text
Paste and format the text in word
But I cannot link the 3 bits together, sometimes it works but run the code a second time and nothing happens.
Most of my code is bits I have found on the net and adaped, I would like to start again Can anyone help me to get started