Sheets('Report').Range('A7') = name &vbCrLf&Street_Address&vbCrLf& city & region & country &vbCrLf& postal Street_Address = Sheets('Main_data').Cells(i, 2)Ĭountry = Sheets('Main_data').Cells(i, 5)

Msg = 'ERROR' &vbCrLf& 'Starting row must be less than last row' Lastrow = InputBox('Enter the last record to print.') Startrow = InputBox('Enter the first record to print.') WRP.Range('A9').HorizontalAlignment = xlLeft WRP.Range('A9').NumberFormat = 'dddd,mmmm,dd,yyyy'

Rename the Command button with the name “Letter”, and now assign below mentioned macro:-ĭim StartrowAs Integer, lastrow As Integerĭim name As String, Street_AddressAs String, city As String, region As String, country As String, postal As String.

Go to Developer tab and then insert Command button from Activexcontrol.

First we will insert command button in the worksheet.There is one command button to move in the report sheet.Ģ nd sheet is having the letter format with 2 command buttons one button to move on the data sheet and second command button is to work for mail mergeįirstly, we will write the VBA code for command button of Main Data. In first data, column A contains Name, column B contains street address, column C contains city, column D region, and column E and column F contain postal zip. 1 sheet contains data with details to whom we want to give letters. We have a letter format in Report sheet, and we want to apply mail merge through VBA in which we want to change the letter details as well. Let’s understand with a simple exercise:. To perform such operation, we use Microsoft Word. Mail Merge: - This is the source to merge the data’s information into text and then print the document.

In this article, we are going to learn how to automate the mail merge by using the VBA in Microsoft Excel.

Mail merge word for mac from excel