Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel to word.
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel to word.
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
excel object linked to word will not add sums in word | Excel Discussion (Misc queries) | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) |