greeman
New Member
- Joined
- Jul 31, 2005
- Messages
- 38
I have read a number of the pdf related topics here but have not seen one that answers my needs:
I have a supplier orders data table which I am reporting in a pivot table. I currently have a macro that cycles through each supplier with active orders and copies the pivot table as format and values into a new sheet, saves the sheet using supplier name in the filename, and then emails the sheet to the supplier based on a seperate data table that includes their email maintained manually.
I have now been asked to have this send as pdf rather than an excel sheet. I have the code for the emailing sorted, but I can't get the PDF creation done. The person who will be running the macro doesn't have Acrobat.
Any pointers or suggestions greatly appreciated.
I have a supplier orders data table which I am reporting in a pivot table. I currently have a macro that cycles through each supplier with active orders and copies the pivot table as format and values into a new sheet, saves the sheet using supplier name in the filename, and then emails the sheet to the supplier based on a seperate data table that includes their email maintained manually.
I have now been asked to have this send as pdf rather than an excel sheet. I have the code for the emailing sorted, but I can't get the PDF creation done. The person who will be running the macro doesn't have Acrobat.
Any pointers or suggestions greatly appreciated.