mail merge

Hi Excel Gurus, I am VBA dumb, but really need your help to solve my problem if you don’t mind helping? Excel version 2010/2013. So my data is driven off a pivot whereby I'll use the filter to generate new sheets based on that filter page option. In this exercise it will be the account...

Hello Experts, I using Word 2013 to mail merge. I have a large list of data (counselor names, student names, scholarships and high schools). I want to mail merge the list so that each counselor gets one letter, but they may have multiple students (unique field is hs_code). I have tried...

I am needing to create student test tickets to be distributed to multiple school buildings. I have an excel document with all the data needed for the student test tickets, and I have the tickets created in a word document template (10 records per page). I can easily use mail merge to create the...

Dear forum, I've been using mail merge within in word (merging an Excel file with my word document) and it has become quite a nuisance since the text file that it generates gets turned into a .scr file to be loaded into AutoCAD. I've looked around on search here (the forum) and there (Google)...

Hello, I have a problem inserting custom data on a word document (from Excel) regarding mass emails. The situation example is like this: Different Companies (A, B, C..) have X amount of different undone campaigns. I am preparing the mail merge in Word and I am only able to put, for each...

Hello Everyone, Somebody please help me out to get VBA code for automatic Mail merge with To, CC, Subject, Attachments, Message Body as <tbody> TO CC Subject Message Body Attachments path </tbody> Since I am very new to Visual Basic, I could not manage to write all codes. I want to...

I have an very large excel spreadsheet. I use a userform for data entry. I have a field that should read a word but it merges a time instead. For example the field should read "Attorney Fee" but instead it reads "12:00 am" instead. The field is "General" and I even tried changing it to...

I have a WORD document with numbered lists. When I do a mail merge with Excel to bring in addresses, it works fine initially. When I save the document and reopen it, the numbered lists are continuous through all pages, all letters, when it should restart with each letter as it did initially...

So this has been a published code - (do not know who the author is) - for mail merge. For my case, I have an excel file with line items and an email column and a purchase number column. I am using Microsoft Word and its Mail Merge function to populate a pre-drafted e-mail to send out to all of...

Hello. I created a user form for data entry into excel which is then used to mail merge. I am in the mortgage and what started out 3 years ago as a simple mailmerge for a loan package has exploded into a huge 10 page detailed word document. I am reaching the end of the 250 column limit for...

Good Evening All, I'm new to this forum, so thanks for reading my question! I have a sheet of data, with 8 columns of data. Column A and B have recipient information (Name and Email Address) Column C,D,E,F and G have information that i would like put into an email, to the person listed in...

I see quite a few questions out here about mail merge but not many responses. I don't know if this can be done but. . . I have an Excel workbook that is a template used by many coworkers. For each new project it is opened and saved as a new, separate document. On a worksheet, I pull...

Hi, I've got a macro which formats a worksheet, opens a pre-formatted word document then runs a mail merge on the worksheet data. Getting a runtime error 4198 and when I run it in the editor it highlights the SQL Statement paragraph and states - Identifier under cursor not recognised. This...

Hello - I am trying to find a solution similar to mail merge, but more streamlined and available immediately upon entering the data. I will have several staff members performing initial health screens. I would like to use a form for staff to enter required information. This information needs to...

Excel 2010 & Word 2010 Hello, I need to complete a mail merge of 150 tables in Word. This is a painstakingly slow process. Is there a way to select multiple tables so I can complete the mail merge at once rather than having to complete each mail merge separately. After each mail merge, i have...

I am creating an Access database for the department I work in. When reviewing orders on a form, there are certain instances were we need to mail a letter out to the customer. I have a command button that opens up a word form and inserts address info from the customer table in access to the word...

Hi, We need to personalize a (.pdf) memo to multiple recipients, from a mail merge (source: excel data spreadsheet), and wish to have the individual memos encrypted since we plan to send the personalized memos via Outlook email-merge automatically. Has anyone accomplished this before? Each...

I trying to develop a formula to return a variance amount from using a vlookup, hlookup, match or index. The is the tab in which the formula would be entered. <colgroup><col><col><col><col><col><col><col><col><col span="6"></colgroup><tbody> Date Name Variance 02/27/15 Mike (99.95)...

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