excel to word.

  • Thread starter Thread starter paul
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My unsolved mystery! 3
Excel value onto word userform 2
How to transfer the data from userform to spreadsheet for specific dates 0
Mail Merge source Access Database using Excel VBA 1
Mail Merge source Access Database using Excel VBA... Pls Anyone 2
Worksheet appears briefly before UserForm opens 4
closing another file by code causes failure to run workbook activate event 2
display message box in excel(2003) using VBA word(2003) 0

Back
Top