Hi,
Will really appreciate if any can help me in guiding how to write VBA code to mailmerg data from excel file and word document to a new word document.
Thanks,
Pooh
Hi,
Will really appreciate if any can help me in guiding how to write VBA code to mailmerg data from excel file and word document to a new word document.
Thanks,
Pooh
Did you notice this forum has a search option ?
Yes i did searched in this forum earlier and i got answers where we can merge from excel to word. But I am facing problem on the front when i merge data from excel and get new document then after this step i have to open word file copy data from it and paste it to this new merged docuement which is not a saved document.
Hello. How's the weather over there in India? I love Indian food. Yum, yum!
If I understand you correctly, you have successfully merged data from excel into a word document. Now you want to merge additional data into this document from a word document.
Can the additional data just be dumped in a block in your document? If so, from your newly merged word document, you could activate a macro which would create a new (second) document, connect to a data source, create the necessary merge fields in the new document (or add them from a building blocks entry), merge the data into a new (third) document, copy the contents of the third document to the clipboard, close without saving these last two newly created documents, and dump the clipboard contents into the insertion point of the your original document.
It may help if you describe your needs in greater detail.
Good luck.
Last edited by Dirigo; 11-12-2011 at 05:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks