Hi,
I have an excel mail merge. The data is in the data tab. The form tab is the letter. There are 2 buttons, "Save as PDF" & "Print Letter (s)". The "Print Letter (s)" picks the row number from which the data is to be selected from the data tab and the "Save as PDF" saves it as a PDF to a designated location. My issue is, I have to put the values after clicking the "Print Letter (s)" one by one manually and then click the "Save as PDF". Can anyone please help in writing a macro which will automate this?
Thanks and much appreciated.
PPG.
I have an excel mail merge. The data is in the data tab. The form tab is the letter. There are 2 buttons, "Save as PDF" & "Print Letter (s)". The "Print Letter (s)" picks the row number from which the data is to be selected from the data tab and the "Save as PDF" saves it as a PDF to a designated location. My issue is, I have to put the values after clicking the "Print Letter (s)" one by one manually and then click the "Save as PDF". Can anyone please help in writing a macro which will automate this?
Thanks and much appreciated.
PPG.