mail merge

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

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

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

Hi all, I'm relatively new to excel vba and i'm i've created a spreadsheet that allows the user to select three options. "Email as PDF", "Open Documents" and "Email as Word Document". The below VBA currently opens only one document whereas i'm looking to open three documents/PDF for all three...