I'm novice guys with a very little vba knowlegde.
I need some guidance in how and what the best possibilities are, and how it will be done best.
I have a workbook where i need each sheet to mail merge into a letter with a button from Excel, is this possible?
Would it be possible to embed the word letter file into the excel file or would it be needed to save the word letter file locally or at a network location?
The letters would need to be merge out from a few chosen columns, which might variate from sheet to sheet, and each sheet has its own letter format and doc file.
What is possible and could any1 kindly help me make this code?
How i see it would be like:
You open the excel workbook, go to each sheet to create its specific letter, click on a button called [Create Letter], the letters will get saved locally in c:/temp folder in its respectable folder named after what sheet it is.
here is the workbook i got help with earlier from Gowflow
Thank you in advance