mail merge

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

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

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

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

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

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

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

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

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

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

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?

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

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?

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

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

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

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

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

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

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