mail merge

Hello, I am trying to merge records with a like cell value in a table on one page of a mail merge and then if the cell value changes, I want the following records to go on the next page and so on. Each record has several merge fields and I can't seem to write a field code that will accomplish...

I'm trying to populate a Word document with info from a spreadsheet. I created Merge fields in the Word doc, e.g. <<Patient_Name>>. The excel book I'm testing with has two tabs, one called Sheet1 that has a row with the field names and a row with the values, the other sheet just has a button I...

Hello I use a macro to save mail merged documents into word and PDF files; very handy. I must select all the rows above the row I need in the recipient list for it to work. If I only ticked "Sam" and left "Connor" and "Vincent" unticked, the macro will produce a "runtime error 5631" on...

Hello, I am trying to create a mail merge spreadsheet which I can use to create employment contracts. Everyone in the company is on the same employment contract and the only difference is the notice period, as follows: Manager During your probationary period, your employment will be subject...

Hi I have this document with all the students marks for a given term. The same can be accessed here https://docs.google.com/spreadsheets/d/18z-l-RLOcf069-3txj_4YwQ6OXALHL_4/edit?usp=sharing&ouid=105636336571610671345&rtpof=true&sd=true What I am trying to figure out that if there is a way in...

Hi I have this document with all the students marks for a given term. The same can be accessed here https://docs.google.com/spreadsheets/d/18z-l-RLOcf069-3txj_4YwQ6OXALHL_4/edit?usp=sharing&ouid=105636336571610671345&rtpof=true&sd=true What I am trying to figure out that if there is a way in...

I need help with a file path not opening in a MailMerge I am trying to write. I copied this code from a YouTube video and after some research on the 5174 error "Sorry can't find your file? Was it removed,etc?" I added the line about replacing Chr(13) but I'm still getting the error at the line...

I have an excel sheet with all the details required and my requirement is to email customized birthday cards to staffs. I want the picture to be inserted in the outlook mail body rather than add as an attachment. The email should go on the birthday dates at the specified time. I have the...

Hi there, I have found some old posts on this topic but nothing that seems to solve my issue. I am using the below formula in order to pull a list of individuals names that have correspondence through the same email address. For example if Mr John Smith, Mrs Jane Smith and Miss Janet Smith are...

Hi all, I've got a worksheet that's part of quite a large workbook to help organise events and contacts. I do about 18 events a year, so it's not practical to do them all on separate worksheets. I all the events in rounds - 3 rounds of 6 meetings. All the rounds in each meeting are side by...

Wondering if someone can help me with the below code. I got made redundant from a company and saved this code for use in the new job. It worked at the previous place but now, oddly, it's saving PDFs with the file extension ".22" (a 22 File). Never seen this before.. The idea of the below is to...

I am trying to generate printable stickers using Mail Merge from Data I have in Excel. The Data I have: Using Mail Merge it turns into this as the Font changes from Code 128 in Excel and into Calibri in Word: Ideally, I would like it to look like the first record automatically but I had to...

Hi, I have created a word mail merge template from data in an excel document, and I think I'm nearing the 256 column limit - so need to check what exactly I'm using and what (out of the 256 fields) I'm not currently using... What I'm after is some kind of macro that will allow me to open up...

Hi all, I'm working from Google Sheets, trying to mail merge the address... I'm wondering if there is anyway to take JUST the Street Address from Column D and put it in Column E below. We got data that had the whole address sans commas. We already have matching data for F through H (City...

Good Morning, I am looking for a solution to quickly help fill rows based on their shared Value in Column D I have several group id (Column D) that I need to have go from this ABCDEFGHIJKLMNOPQRSTUVWX1id_numlast_namefirst_nameGroupIDmobile_phoneemail_addressRoom 1 IDRoom 1 LRoom 1...

Good Morning, I am looking for a solution to quickly help fill rows based on their shared Value in Column C I have several group id (Column C) that I need to have go from this To This Please let me know if you need more information

Hi, I have a spreadsheet that is populated with data. Each column has a header and there can be many rows. I want to copy/export a selected row of data to a Word Template, Save the Word file as Filename.Doc Close trhe Word Application and then return to Excel (Command Button that calls...

I am trying to do a mail merge from an excel file that has multiple rows for each employee. Each row lists an application or process they are not qualified for. The data is provided in an excel document and currently we are copying and pasting it into a word document to then sending to...

Have a quick question for the pros... I have a mail merge setup through VBA that has worked perfectly for quite some time now. The source word file (.docx) has a header that includes a seal, and for some reason the seal has failed to be on the output document. Only a place holder for it. This...

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