mail merge from excel

I am running office 365. I have a macro enabled word template that I use to create a customer proposal document that uses mail merge fields pull customer specific information from a cost estimating work book. When in word I would rather not have to hit -> Mailings, -> Select Recipients, ->...

I'm trying to automate some of our processes. On a daily basis, I run the same query in our software (for current orders and details) and open the results in an Excel sheet. I've set up an Excel macro to make the same changes to every report. Now I have to print and distribute a report with...

Dear All, I have a below code to open an existing word file. The word is mail merged to a different excel file. I just need to open the word file, and automatically it will be mail merged with excel file, and open the new output word file and autosave it. Option Explicit Sub OPENWORD() Dim WD...

I am adapting some code to make a mail merge work directly from Excel using a Gmail address, but I am having some problems. Any help would certainly be appreciated. I want this to send an email to every column that does not equal "not scheduled this week" in column "I" my info is in the...

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

Hi all, I have a mail merge list (tabname "Datasheet" which runs a mail merge fine however I want to add a few extra steps which I cant appear to be able to do in word. As well as sending to one person I want to CC a number of other people (based on column J in the datasheet). Also I would...

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

When I do a mail merge, "fake" columns are created, and my letters wind up with the wrong information in them. For example, in my Excel workbook, I have columns labeled F! through F13. In the mail merge, there will be a faux column number of F113. There is no such column in my workbook. Does...

I have data set that contains ID numbers on Column A that repeat multiple times and vary from ID # to ID #. For example ID # 123 may take up 17 rows, while ID # 456 may take up 5 rows. To add complexity, within each ID #'s rows, there are two types of data they can fall under (i.e. ID # 123...

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

hi all i have sheet witch contain data and i fill data on it then it's calculate , finally i close it and go to word document witch already have letter mail merge , then i print some of it , maybe record #1 , maybe from record 1 to 50. i want to use macro to run it from excel to 1.run mail...