Hey hey people.
I was tasked with making a macro which combines two ranges into one pdf, one sheet for each range, and sends the single pdf to a list of emails. I have managed to get two seperate pdfs sent to the email list, but I am pretty stumped on how to combine the ranges. I initially came across some promising resources with Adobe Acrobat on this post Loop through files in folder that match part filename, but of course my computer doesnt have the software, and even if I were to get it, this Macro needs to work on many employees computers, so no cigar there. Perhaps if there were a way to get this software installed like a Reference? (this seems like a longshot to me)
My other idea was to copy the two ranges onto a new worksheet, "join them" together and just select the two ranges as one. This does work, but it absolutely messes up the formatting (merged cells, different column widths and row heights, different widths of ranges in general), so while this could work there may be a simpler way.
Does anyone have any suggestions as to what I could do? I can post my code if necessary but this seems more like a brainstorming sort of problem. Ill make sure to post my edited finished code if I manage to solve this particular part.
Many thanks and happy 2022!
I was tasked with making a macro which combines two ranges into one pdf, one sheet for each range, and sends the single pdf to a list of emails. I have managed to get two seperate pdfs sent to the email list, but I am pretty stumped on how to combine the ranges. I initially came across some promising resources with Adobe Acrobat on this post Loop through files in folder that match part filename, but of course my computer doesnt have the software, and even if I were to get it, this Macro needs to work on many employees computers, so no cigar there. Perhaps if there were a way to get this software installed like a Reference? (this seems like a longshot to me)
My other idea was to copy the two ranges onto a new worksheet, "join them" together and just select the two ranges as one. This does work, but it absolutely messes up the formatting (merged cells, different column widths and row heights, different widths of ranges in general), so while this could work there may be a simpler way.
Does anyone have any suggestions as to what I could do? I can post my code if necessary but this seems more like a brainstorming sort of problem. Ill make sure to post my edited finished code if I manage to solve this particular part.
Many thanks and happy 2022!