mail merge

Hi all, I already have a word document with mail merge linked to the excel spreadsheet. Now I created a button in this spreadsheet and I want to be able to click and open the word document. I have tried several times, but it will only open the word document with no mail merge. I tried all the...

I'm try to save a mail merge document on word into individual files. I have been using the VBA code below, it works to save the individual files., But it changes the font and doesn't copy over the format of the document correctly i.e tables header and footers etc - could some please help with...

I am trying to use VBA to print some word docs that were just generated through Mail Merge code, and for some reason I keep getting this message" This action cannot be completed because the file is open in word desktop". Not sure why, but am pretty sure the problem is in the Mail Merge code. Its...

Hi Excel World! I've spent the last couple hours trying to find an answer in one of the forums regarding how to do a mail merge with a unique subject for each email from a column in Excel with no luck. I am new to VBA but understand some of the coding language used. Simply put I would like to...

Hello, I have an excel file with different worksheet of the individual officer (i.e. 40 officers which means there are 40 worksheets) on their list of projects that they are managing and their involvement (by man-days) on each project. The data in each worksheet is presented in a table form and...

Ultimately I am aiming to have a mail merge document whereby the user inputs a variable which filters on that input and produces the mail merge purely for the row that has that code. At the moment the coding doesn't include the variable as I've been unsuccessful in getting the filtering to...

Hello, I have a word doc that I have set up as a mail merge from my excel file. I would like to be able to select a cell (a single recipient) in excel and have a user click a button ("Print") and have the paperwork print out for the single recipient that is selected. Is there a way to do this...

Hi All, Just have a quick question for the community, quite a complex mail merge just tying to find out what the best way to get to the solution. I’m trying to create a mail merge, into a word document and then to be sent out via outlook (I am on office 2016) data source is in excel. However...

Hi, I need to format a data set for a mail merge. In essence I am looking for help on how to remove blank columns and replace it with the value of the next non-blank cell in the row (without the use of Macros). Blank values are allowed in the Widget columns are allowed Each email address will...

I have a list including two columns which I use to mail merge in Word to print labels. One column contains names the other numerical values. Is it possible to tell the mail merge to print each label the number of times equivalent to the numerical value against that name? For example two cells...

SUMMARY: I've got a sheet of data that I need to have exported to Word via a mail merge, and this specific task happens regularly enough that I want to automate it, especially for other, not particularly tech-savvy, people who have to do this from time to time when I'm not available. Is there...

I have a spreadsheet that is used for a mail merge and it is constantly having rows added. Is there a way to "Mark" a row that has been successfully mail merged with Word? I am thinking along the lines of adding a "X" in the last column, so when I do another mail merge I can set it up to skip...

Good Afternoon! I have a spreadsheet where I track return requests and this is how I envision the process working: A new row is enter into the sheet, column "W" is automatically populated via a formula with either "YES", "NO", or "Need Manager Approval". If the column contains "YES" an email...

I am looking for a method of creating a set of emails fitting the following parameters: -each email will be personalized to the recipient and based off a template letter set by my supervisor. -There will be a greeting line with their name and title, along with the names of the departments they...

I am creating one word report (Office 2013) using mail merge wherein data will be fed into excel sheet and it will be used as a data source for mail merge. I am able to achieve all this, but now I have a requirement of Tables in the same word report . The table is dynamic in nature, I want to...

My project: Sheet with two browse button and one run button, 1:one for Excel data - Data source for mail marge and 2:another for word data - word Template of my letter. Once i click the run button , needs to run the mail merge in word and split the data into individual and save as doc and pdf...

How would one go about writing a macro that prepares Word documents like letters or reports. I am using a Userform to enter the information and would like to add a button on the user form that brings up the word document. Ready to print, but does not print it. I am currently opening the...

Hi all, I have an excel set up for with data gained through site testing (this includes a mail merge worksheet, putting data into mail merge friendly format) and these will all be saved as seperate files, and i also have a mail merge that is set up to put this into a report that can be sent to...

Hello All! I have been trying to find a solution to this problem for a while, but to no avail. I have data in an excel spreadsheet with names addresses and such and I already have a word doc set up and it is linked through a mail merge. What I need is to have a macro that I can added on to...

I currently have an excel sheet which serves as the input to a mail merge for a word doc. I want to write code so that at the push of a button, the excel sheet will save and the merged word document will open. However, for some reason when opening the merged doc like this disconnects the data...