Hello
Excel Ninja had offered in this link below sometime back to mail merge in excel. see link below.
http://forum.chandoo.org/threads/dynamic-printing_-or-mail-merge.17426/
I have this macro that i was able to make it work it to print excels. in other words, I can mention the number of records and it will print to the printer, as many letters. however, i want it all letters to a single combined PDF. This way i can review all the letters in the pdf and save it before printing. Can someone please help?
I have copied the macro in the attachment below. Please let me know if you need me to send any other info.
start row- no. of the first letter
end row- no. of the last letter
rowindex - current letter being viewed
dashboard -the letter
Thank you very much
__________________________________________________________________
Excel Ninja had offered in this link below sometime back to mail merge in excel. see link below.
http://forum.chandoo.org/threads/dynamic-printing_-or-mail-merge.17426/
I have this macro that i was able to make it work it to print excels. in other words, I can mention the number of records and it will print to the printer, as many letters. however, i want it all letters to a single combined PDF. This way i can review all the letters in the pdf and save it before printing. Can someone please help?
I have copied the macro in the attachment below. Please let me know if you need me to send any other info.
start row- no. of the first letter
end row- no. of the last letter
rowindex - current letter being viewed
dashboard -the letter
Thank you very much
__________________________________________________________________
Mod edit : thread moved to appropriate forum !