mail merge

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. D

    Automatically Email Rows Based on Cell Contents and Conditions, Possibly Via Mail Merge

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

    Trying to Create personalized emails, from a template, with multiple attachments

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

    Mail Merge- Dynamic Tables

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

    Mail Merge and split into individual pdfs and doc with filename from the data.

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

Some videos you may like

This Week's Hot Topics

Top