Forum Discussion
Using mail merge in excel without word
I need help to set up macros in excel spreadsheet that can print tax receipt. I have one tab contains data and one tab is the tax receipt template. How can I set up macros to choose a range of reco...
I am working to keep all the files in excel and would like to basically merge excel info into an excel template. I know you can merge into an excel document and I see the one that turn the info directly into a pdf, but I do not see one that puts it back into an excel document with a merge. Is that way not possible? It seems to me that I will have to have a template pre-made for each and just connect the worksheets? Thank you for any help you can give me.
crossmountain2005 I use an XLS table of data to generate many XLS files based on a template, and each of these is optionally also converted to PDF. Does that answer your question? This is done through VBA programming however.