excel to word.

P

paul

I have a userform from which the user fill in numerous
fields which are to be put into a word document with a
mail merge. How would i go about doing this? Does the
information have to be in any particular form and does
anyone know a neat little macro which will make excel do
it all for me?

The userform is in place and the letter template is in
place, it's just swapping the info i'm having trouble
with.
 
A

AA2e72E

When you do a mail merge, Word is in the driving seat. Your requirement is for Excel to be in the driving seat
Either: write your Excel data to a text file and then do the mail merge in Word asynchronouosly
Or: Use DDE (definitely not recommended). The help files have examples of DDE.
 
Top