mail merge

Dear Mr. Excel, First of all, thank you kindly for the wealth of information stored in this forum - it has helped me tremendously in my recent projects! I am trying to extract cell values from Excel to complete a Word template. I have completed Mail Merge tags on Word and it works...

I have a mail merge document and wish to complete the merge and save each document as an individual file based upon an Excel field. Example: Arbitration agreement (document) + employee names (Excel) = Word document or PDF files saved as "Arbitration Agreement - employeename.doc" I have...

Hi all, I am developing a excel tool for mail merge. It can be used to send mails (with attachment) from Outlook or Lotus Notes based on selection. For Outlook, the tool is working perfect but the issue is with Lotus Notes. Mail is generating with content but attachment is missing. Code...

I have an excel workbook where the first sheet is a summary of all accounts and each sheet after is a summary per account. I'd like to automate a mail merge with existing templates already established for the merge. The code below successfully opens the appropriate Word template(s) but says...

I have an excel workbook where the first sheet is a summary of all accounts and each sheet after is a summary per account. I'd like to automate a mail merge with existing templates already established for the merge. The code below successfully opens the appropriate Word template(s) but says...

I want my excel file to open up a separate word document template and run a mail merge using VBA. So far I only have the code to open up the word document from excel: Sub OpenTemplate() Set appwd = CreateObject("Word.Application") appwd.Visible = True End Sub How do I...

Hello, I have an excel file that has 50-100 rows of contact information. I use Microsoft Word's mail merge function that uses this excel file as the data source to fill in different blanks on the template with contact information. I currently save all 50-100 results from the mail merge as PDFs...

I have a mail merge directory that i've created using MS Word, which pulls data from an excel spreadsheet of project team itineraries. The data is constantly being updated - people quit, locations close, people run over schedule at a stop on the list, and so the reports need to be constantly...

I wasn't able to resize the tables as well as put the charts and tables in a single email when it runs, it end up having charts in one email and tables in another email. How do I add the texts as well? This is the expected result: Here are my codes: Public Sub Insert_Charts_In_New_Email()...

I have a huge project, and I am looking for some assistance. I usually do single entries for Mail Merge, meaning one letter is one row of information, easy peasy. The current project I need to merge is not one row every single instance. I have a list of patients, sometimes the list is one...

Hello All, It has been quite a while since I've been on this site. I'm glad to be back. Word mail merge is quite easy to use but it does not allow you to send one message to multiple people (To: or CC:). I'm looking for the easiest way to perform this. I have to send notifications to over...

Hi All, Well my need is quite unique because I want a macro to make another macro which will run on Microsoft Dynamics Great Plains. I will be brief to explain but if you want more info please let me know :) Please consider the following example for explanation... <tbody> S. No. Voucher No Job...

Can you use mail merge to take data from excel and put it in to a word doc table and then when the table is full it starts a new page with new table? I have a Word Doc that I use for tracking ingress and egress. The table holds 20 entries. I’m trying to use mail merge to take data from Excel...

I have been able to use vba somewhat, by lookiing into other file codes, but I need a lot of help! I have an excel file, "Estimate of Charges Worksheet.xlsm", with calculations on one tab. Those calculations transfer over to a hidden tab in the file with named columns for the data. That tab...

Hello, I have had 2 instances recently where I have struggled with merging excel into a mail merge and the format did not merge correctly. In the first, I had a per diem automatically calculated, which generated a very long decimal point. I formatted it to 2 decimals, however when it...

Hi all, Similar to this post http://www.mrexcel.com/forum/excel-questions/584959-mailmerge-uk-date-format.html I am using Office 2010 and have short date formatted columns in Excel and the field code {MERGEFIELD Anticipated_Start_Date \@ "dddd, dd MMMM yyyy"} in Word - yet some of the dates...

Hello, I have a spreadsheet in Excel with First & Last Name combined in one column and three other columns.The columns are as follows; <tbody> First&Last Name Username Password Email address ChristineMurray CMurray_HP Test!23 Cmurray@tbh.com ChristineMurray CMurray_GH Pts.345...

Hello, I have a large inventory list I've created in excel. I need a macro to create X number of labels from data in the table. It has 13 columns and a running number of rows. I've been looking around for a few months now but haven't found anything that works for me. Is this even possible? does...

Hi All, I am new to vba. i have found a word vba which is saving individual mail merge to pdf files. But for this i have to pick the folder to store the pdf files. Is it possible to modify the macro to automatically save all files to a particular folder location instead of manually selecting...

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