mail merge

  1. D

    Compiling Data For Mail Merge

    Good Morning, I am looking for a solution to quickly help fill rows based on their shared Value in Column C I have several group id (Column C) that I need to have go from this To This Please let me know if you need more information
  2. P

    Export data from Excel to Word template and save output as *.doc usiung VBA

    Hi, I have a spreadsheet that is populated with data. Each column has a header and there can be many rows. I want to copy/export a selected row of data to a Word Template, Save the Word file as Filename.Doc Close trhe Word Application and then return to Excel (Command Button that calls...
  3. M

    Is there a way to run a mailmerge that merges multiple rows into a table based on a key field?

    I am trying to do a mail merge from an excel file that has multiple rows for each employee. Each row lists an application or process they are not qualified for. The data is provided in an excel document and currently we are copying and pasting it into a word document to then sending to...
  4. C

    Mail Merge not formatting correctly

    Have a quick question for the pros... I have a mail merge setup through VBA that has worked perfectly for quite some time now. The source word file (.docx) has a header that includes a seal, and for some reason the seal has failed to be on the output document. Only a place holder for it. This...
  5. A

    Mail merge with excel

    I use excel spreadsheets (xls, DDE) as the database for my mail merge in word. After the upgrade to Word 2016, the excel open a new file (Book2) automatically when I open the word file. The main problem is that when the new excel file (Book 2) was opened, all the previous entered data was not...
  6. R

    Dynamic Table in Mail Merge with different page for key attribute

    I have to prepare letter for students of different colleges. For each college, there should be one letter with name of all the students & their details in tabular format. The students data is in excel is as below: <style type="text/css"><!--td {border: 1px solid #ccc;}br...
  7. O

    Mail Merge Data From Excel into Fillable PDF

    Hello, I have a fillable pdf document and want to mail mergeinformation from an excel spreadsheet. The field names on the pdf document and the headings on the excelspreadsheet have the same name. I havebeen successful doing the mail merge from an excel spreadsheet into a Worddocument, but...
  8. O

    Mailmerge/PDF/Outlook VBA

    Hi all, I'm relatively new to excel vba and i'm i've created a spreadsheet that allows the user to select three options. "Email as PDF", "Open Documents" and "Email as Word Document". The below VBA currently opens only one document whereas i'm looking to open three documents/PDF for all three...
  9. L

    How to open a Word document contains mail merge with Excel VBA

    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...
  10. S

    Mail merge to individual documents not copying over formatting

    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...
  11. C

    This action cannot be completed because the file is open in word desktop

    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...
  12. A

    Mail Merge with unique Subject, CC & Attachment using Excel & Word 2013

    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...
  13. S

    Can I do mail merge in which the data source is a pivot table?

    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...
  14. M

    Filtering Mail merge using Word with Excel data source

    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...
  15. C

    Macro to automatically mail merger and print - Code Needed

    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...
  16. R

    Mail Merge - multiple email in a cell

    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...
  17. M

    how to remove blank columns and replace it with the value of the next non-blank cell in the row

    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...
  18. A

    Additional mail merge items dependent on value

    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...
  19. J

    VBA to open Word and run mail merge on currently open spreadsheet

    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...
  20. D

    Mark Completed Mail Merge Rows in Excel

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back