Mm.DataSource.FirstRecord = mm.DataSource.ActiveRecord Mm.DataSource.ActiveRecord = wdFirstRecord NameFile = "WRITE COLUMN NAME FROM MAIL MERGE" I still don't know why I couldn't make work the old code, but this code works perfectly: Public Sub Mail_Merge() I managed to find a solution to my own problem. You can import an Excel data table into Word to customize your template with names and addresses. I need to set that name to a value I store in the Excel Worksheet and also use in the Mail Merge. Now write the content of the email message. The problem is that the filename is a number like 0001, 0002, etc. Then follow these steps to mail merge from Excel to Outlook: tab, select the from the menu. Under General, select the Confirm file format conversion on open. SaveAs "C:\Users\Alessandro\Desktop\excel udine\TRIESTE\" & Format(i, "0000") _ Dynamic Mail Merge to Capture Excel Formatting Open Word, choose File > Options > Advanced. I found this VBA code online and tried it in Word: ' Modulo1 - Modulo' I need to do the Mail Merge in Word with Name, Surname and Birthday.Įvery Mail Merge has to be saved in a different file (in the end, we'll have 10 files, 1 for each row).Įvery file has to be named as the relative Surname extracted from the Mail Merge.
My Excel has a table with 3 columns called Name, Surname, Birthday. Then follow these steps to mail merge from Excel to Outlook: tab, select the from the menu. Sub OpenWordandMerge1 () Dim wordApp As Word.Application. I need to be able to just put a button on the excel file that will merge the appropriate letter, then close the form letter. The problem is every Mail Merge has to be saved as a different Word file and, also, every file has to be saved with a name from the data used in the Mail Merge. My form letter is already linked to the data source, and will merge after excel calls it up, but wont merge from the vba. I need to do a Mail Merge in Word that uses the worksheet's data.
#Email merge from excel full#
I have a letter written in Word and a worksheet full of data in Excel.
0 kommentar(er)
