mail merge

  1. S

    pivot chart inserted mail merge in word

    Hi, I have to create personalized compensation statement for each of our employees using word. There are 150 employees. I input their salary and fringe benefits into an excel spreadsheet for each employee and then do a mail merge. I did this last year by: 1)Creating a pivot table 2)Creating a...
  2. K

    Problem using Offset in an IF statement (VBA)

    Hi and thanks in advance for any help. I am using the following code to automate a mail merge through excel at the click of a button. Option Explicit 'change this to where your files are stored Const FilePath As String = "C:\Users\chowell\Desktop\" Dim wd As New Word.Application Dim...
  3. A

    How to create a mail merge with excel - Help?

    Hey, I am wanting to create an invoice for the customers which have placed an order with my system, the invoice will be created on Microsoft word, and printable. It should contain the data from a specific sheet called "All_Orders" in my spreadsheet. How would I create a mail merge between these...
  4. M

    Mail Merge Macro to produce multiple documents

    Good day everyone. I am new to the site but have been playing around with excel/VBA etc for a while but have recently had an issue that for the life of me I cant resolve. I am trying to produce a document using a macro from excel to a template file using mail merge. All works fine until I have...
  5. M

    Advance Mail Merge

    At work I have to track volunteer hours for a bunch of people across several events. We then print out certificates for these individuals. At first I thought a simple Mail Merge would do the trick, but ran into some formatting issues. Then I went to access, but ease of data input would be an...
  6. A

    Mail Merge and Spreadsheet Automation Using VBA

    I designed a workbook that basically tracks and helps follow up on internet leads I receive, and in the evolution I've gotten in way over my head. This workbook uses 6 different sheets, titled "Fresh" "2 Days" "5-7 Days" "14 Days" and "30 Days". The lead has an Age on it, which corresponds to...
  7. L

    Dynamic Charts in Mail Merge

    Hello all, I'm trying to find out if there is a way to create a pie chart as part of a mail merge letter without using VBA. Essentially, my company is trying to create a form that will tell each employee what their entire compensation is, not just their weekly paycheck (company-paid health...
  8. S

    Mail merge - wrong information being picked

    Hello, Would like to give a solution to a problem I was facing in Mail Merge where wrong information was getting picked. Some others might face the same issue so this might be useful for them... My data in excel is as follows: <tbody> Apples Oranges No of orders 10 20 </tbody> When I was...
  9. M

    Excel data list to Word mail merge?

    I have an excel list of names, dates, and amounts owed that grows each day. I want to generate a report (using parameters) that allows me to print out summaries for each name (theoretically using mail merge?). The data looks something like this: <tbody> Name Date Due Amount owed Mr. Smith...
  10. B

    Parsing / Merging / Grouping Multiple Rows for Mail Merge

    Hi folks, I was hoping some of you geniuses could help me with this problem. Ultimately I need to mail merge data based on a data source being fed into Excel ideally without using Macros as I know nothing about them. My Dataset looks as follows - Code,Title,First...
  11. A

    Mail merge with different pictures

    Hi, Is it possible to do a mail merge with different images for each mail merge? And have different colour of text according to some data?
  12. H

    Excel 2007 Sheet as a Data Source For Word 2007 Mail Merge

    Hi All, I have data on two sheets of a workbook which are joined by a VLOOKUP. I have the data I want to use in a mail merge on one of the two sheets in this workbook, but, when I create a new data source for my Word Merge using ODBC data sources, the workbook only contains one sheet, and it...
  13. F

    Mail Merge

    I can only use the 1st Sheet of my Workbook when I'm selecting my Database. I have 2 other sheets under the same workbook. How can I be able to select these and use the information that's in there?
  14. A

    Mail merge date format selectively ignoring field codes

    Hello all, A colleague has stumped me with this problem. A mail merge involving a UK format date from excel 07 to Word 03 selectively ignores the field codes set in the Word document. The date should be 2nd July 2013, displayed as 02/07/2013, but comes out as 07/02/2013. Now, we are not...
  15. E

    From MS Word, using Mail Merge, it doesnt present entire set of rows to select

    From MS Word, using Mail Merge, it doesnt present entire set of rows to select. MS Word Mail Merge Edit recipient list When it pulls up the list from the Excel file, the rows it presents stop after a certain row. I don't see a visible problem with that row. If I delete the following row in...
  16. I

    Very Complicated Mail Merge

    Hello, I am trying to create a merge template of my faculty "database" (not a true database, but a massive spreadsheet that acts as a reporitory of info). The issue I am running into is a faculty member will have several activities listed, but I only want 1 document generated with all of the...
  17. J

    Word 2010 Mail Merge to save to individual .docx files

    I'm new to VBA and have not worked with macros in word much. I have a form that is a large table covering an entire page. The form has custom margins: TopMargin = (0.5) BottomMargin = (0.19) LeftMargin = (0.6) RightMargin = (0.6) I have been attempting to do a mail merge to add assigned acct...
  18. R

    Mail Merge + save as pdf + Individual attachment + send email to individual person

    Hello , Please anyone help me to create VBA macro !!! I wanted to create single macro which has below facilities -> It should use mail merge as i wanted mail to send same mail to 3000 person -> Individual mail to individual person with individual attachment facility -> I have 5 or 6 details...
  19. I

    Access to publisher mail merge and save PDF as unique files...

    I thank you all in advance for any help you can provide me, I am looking to perform a mail merge from access to Publisher. I have linked everything together and got everything looking the way that I want it to look however... What I want to do is when I perform the mail merge I would like...
  20. A

    Changes in macro for mailmerge

    Hi, I am new to VBA and I tried the following VBA code which I found from a website. It is working, but the problem is the individual document format is different from that of the mailmerge template. But I want the same format as it is the template. Option Explicit Sub...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top