I'm trying to streamline the data entry process in my company with regards to a new service. Right now we input customer order info into a Word document, retype the same info into an Excel spreadsheet, then copy and reformat the information into an Outlook email to the customer. I would like to reduce the data entry to one point, which can be merged into all the different programs easily. Is this possible? Do I need a fourth program to manage all this, or can it be done with one of these programs? If so, what are the functions I will need to master? I'd really appreciate the help. Thanks!

Dan

Hi Kidatonal,

The compatibilities between Excel And Word has been an issue for years now.I have in fact raised this issue with Microsoft to include a merge function for word in their next addition but as always it has fallen on deaf ears. I understand your problem and think the only logical thing to do now is to basically copy your formats over to excel and paste it as HTML. THis way you won't lose the colums you created in word. As far as Word > Excel > Outlook is concerned, you will have to give me some more specs on what you need and I can write a vba code to solve this issue. Please get back to me if you need more help...

Regards
gareth