Hi Gurus My work relates to prepare a large number of reports and I use mail merge for all this process. I have to save each and every report separately. The file name I need to use is also generated through mail merge at the very first line of each report in MS Word document.
What I need is when I apply the save as command on MS Word the new file name is fetched from the first line of the report (a combination of Ref No, Name, country or whatever). Please help me out in the issue. Thanks AZHAR RAI Islamabad, Pakistan +92-333-552-7731 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe