I have a section of an excel form that I need to populate with text from a word document. It could be 3 lines or 300 depending on the size of the work order. How can I build a template that will allow me to paste the information into a merged cell section (1 row by 6 columns) that would automatically resize showing all of the pasted text? The reason I have to use excel is I have sections of the document where I use vlookup to populate fields. After I have everything populated I then send on via email with the excel form in the body of said email. I was thinking of saving a working form of the spreadsheet as an outlook template but don't think that would work..........Any suggestions?
Bookmarks