Forum Discussion
Mimi Wong
Feb 01, 2017Copper Contributor
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...
John McGhie
Feb 02, 2017Copper Contributor
Hi Mimi:
Your question is too broad in its current form. What I suggest you do is to record a Macro to print just one tax receipt. Post the code that gets recorded here, and we can show you how to modify it to enable you to select a record to print.
We will need details such as "how do you decide which record to print?", "which version of Excel are you using?" and "Which licence type do you have?".
Excel is a very large product, and not all licences have access to all of the features: we need to know what will work in your setting and what won't.
You will find a "Record a Macro" topic in the Excel Help that will get you started.
Hope this helps