I know how to open and Excel spreadsheet from VB and then save it with a new filename. Also I can open a Word document as a template but does anyone know how I can get information from the Excel spreadsheet(certain cells) into my Word document in a specific position (like a mailmerge)
Is this possible? and if so how please?