So Im working on a project where I want to take the reviews from our employees and put them on letters and email them out. Every employee has 1-4 reviews and multiple questions answered for each- normal mail merge would send someone 4 letters with the review info & I'd love to have it all pulled into one. I made a fake one & attached below. I've tried a couple of formulas I've seen online but none of them have worked.
I have an excel sheet that our sales staff enters data on and I'm wondering if there is a way to send an E-Mail to certain people if they answer yes in cell S44? I want this to send an E-Mail telling the intended person that they need to perform a "First Article Inspection" on an item that sales has just finished with. The excel is 2003 and everything runs through our network.
I need to send 25 mails on daily basis to my client. All fields in mail are common except recipient and attachments. Every mail has 3 excel attchments. So i created a macro in excel which sends mail as per my requirement but picks up only one attachment from the path i have mentioned in the vb code. Whole macro is running perfectly. I just want to know what modification i should do in that code to attach more than one excel file to the mail from the path i have given. Below is the code:
Sub macro1() Dim sFolder As String Dim Folder As Object Dim file As Object Dim fso As Object
I've been trying to send emails through an SMTP server in various ways. I've been able to send email using CDO going directly through an SMTP server on my same local network (not requiring a username and password). But now I am trying to send email from my home with the SMTP server I am using that is hosted by some commercial company. I used the code below, which is sponsored by Paul Sadowski:
Sub sendMailRemote() 'Sending a text email using authentication against a remote SMTP server
Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup directory. Const cdoSendUsingPort = 2 'Send the message using the network (SMTP over the network). Const cdoAnonymous = 0 'Do not authenticate Const cdoBasic = 1 'basic (clear-text) authentication Const cdoNTLM = 2 'NTLM.......................
I am a teacher and my department uses Excel for grades. We need to be able to print grade reports for students. We currently use a mail merge to do this, but some teachers are having a hard time with this process. They don't seem to understand using the two programs together.
I want to do a mail merge from a pivot table. The pivot looks like this (bit simplified ;-) :
Name JanFebMar Joe $12 $23 $34 joe(a)test.com $12 $23 $34 Frank $45 $56 $67 frank(a)test.com $45 $56 $67 Alex $78 $89 $90 alex(a)test.com $78 $89 $90
Created with: Name and e-mail as row items, months as columns and cost as values.
In the e-mail I want to address the person by his name and use the right e-mail address to send it. So ideally (I think) the pivot should look like this (e-mail address in the column next to the name instead of under the name):
Name e-mail JanFebMar Joe joe(a)test.com $12 $23 $34 Frank frank(a)test.com $45 $56 $67 Alex alex(a)test.com $78 $89 $90
Now the problem is that I can't place e-mail in the column section of the pivot... Instead of placing the e-mail addresses vertical beside the name they are place horizontal...
I have a sheet of 2000 rows. What I want to do is merge the information into a word document with 8 rows of information on each sheet. These will then be printed and guillotined. what I want is to have the information for the second row to appear under the first one and so in position 9 and the third under that in position 17 and so on so I can just stack the piles up and they will be in order rather than having to sort them all into order. I do not know if there is anyway of tell word what oder to put the records in or if I will have to use a formula in excel.
If I have to do it using excel I need to be able to have a separate column which i can sort and it will then be in the right order for the merge. The first row will be 1 then 9 then 17 (adding 8 each time) up to row 50. Then row 51 is 2, 52 is 10, 52 is 11 up to 100. Then row 101 is 3, 102 is 11 and so on and so on.
I have an Excel spreadsheet with names and addresses which I want to mail merge into a letter on word (annual benefit statements). The names and addresses on Excel have been imported from system software and are all in capitals. Is Excel smart enough to be able to keep the first letter of text in a cell but to change the remaining letters to lower case?
I am doing a mail merge and one of my columns is an interest rate. It appears normal in my spread sheet but when I do the mail merge some of the number are extending about ten digits, for example, on my spreadsheet it is 5.75, on the mail merge it would be 5.759999999. It appears to be totally random.
I've succesfully managed to get the mail merge functioning from within Excel at the press of a button. I had a problem initially Word not shutting down properly but have solved this.
The problem I have now is that after the merge has finished and the spreadsheet is saved/closed and Excel is closed, the process tab in Task Manager says that Excel is still running. I found other instances on the net in other forums of people having a similar issue but alas no solutions. The full code for the procedure is below:
Private Sub cbMerge_Click() Dim wrd As Word.Application Dim mydoc As Word.Document Dim lastrow As Long Set wrd = CreateObject("Word.Application") wrd.Visible = True Set mydoc = wrd.Documents.Open("U:TSD3-Projects11-CBRNCBRN-036-CVF HVAC Main Contract-T13212-WorkingECR FolderTESTINGEQR Test.doc")
With wrd.ActiveDocument.MailMerge .OpenDataSource Name:= _ "U:TSD3-Projects11-CBRNCBRN-036-CVF HVAC Main Contract-T13212-WorkingECR FolderTESTINGECR Log TESTING.xls", _..................................
I am looking for a way to make the data mail merge friendly for our clerical staff! The intention is to be able to create a letter to the parents listing the dates absent and unexplained.
There are currently 7 columns ; ID, Surname, First Name, Current Level, Current Form, Absence Date, Absence Code.
I have downloaded and implemented ASAP Utilities and the Transpose funcion is really useful - however it works in predetermined steps - 1, 2, 3, 4 etc rows of data are transposed, depending upon the number you select. Unfortunately there is no such pattern - each student thas a different number of unexplained absences. Some have 1 while others may have 20.
I have a database of around 300 names and addresses from which I need to print labels .....
If not what is the best way to do it. Can this file be converted to a doc or mdb file and then mail merge in MS Word. Could somebody please reply at the earliest as I have very little time to create these labels ?
Is there a way i can dictate to Word from an Excel macro that i want it to open, Start a mail merge, use a pre-made file as a template, use the excel file the macro is in as the source, get it through the whole setup of the Mail merge all the way to the print function?
This macro, enabled in Excel, is part of a chain of macros and will open Word, run the mail merge, save and close Excel. However, there is a macro in Word that I need to run but don't know how to activate it. Is there a code that I am missing that can be added to the end of the macro included?
VB: Sub Mailmerge() Dim wd As Object Dim wdocSource As Object [code].....
The database is full of customer bookings and the email side is for sending automated emails regarding There Gift aid donation.
Im trying to run an Automated mail merge from excel via word. Basically im opening an a spreadsheet which has the same information as the Mail merge data source, its a refresh-able Query from microsoft query . I want to be able to click a button that opens up Word and produces an email mail merge and sends it to my outbox. So the emails can be viewed before the final send. I am using Office 2013.
Once i have this stage working i want to eventually move on to having a field on the main spread sheet automatically fill in saying Sent with a Time Stamp.I want to send either email or print a letter depending on what Address/Email information they have.There may also be multiple bookings from the same Customer e.g Restaurant and house booking, which will show separately, and i want to some how have a condition that it puts all the customers Bookings onto one mail merge letter, instead of sending 3 separate letters to one customer.
This is my code so far:
VB: Sub OpenWord() 'Setting up Word Application Dim wdApp as word.application On Error Resume Next
Dim wdApp As Word.Application Dim wdDoc As Word.Document
I am trying (and failing) to set up a mail merge with a Word document. I would like for the doc to take information entered in specific columns and display it in the right field. I've set up the field and the excel doc and went through the mail merge wizard's steps for setting it up but it doesn't seem to be doing what I want.I am attaching the doc and spreadsheet below.
MichaelFields TEST.Contract Entries.xlsxFields Test.Contract to Provide Legal Services.docx
If I have a simple spreadsheet with Name, Class, and date in Columns A, B, and C. Labeled as NAME , CLASS, and DATE acccordingly is there a way to merge that data onto a certificate in powerpoint so the result is a slide of each student?
I can do this in word easily and perhaps the easy answer is to just convert the certficate slide to word and go from there?
I have a database that uses a few basic macros that I would like to use as part of a mail merge ---> Form Letter. Word does not seem to support the use though of xlsm files as a data source though.
Full disclosure - I am using a mail merge form letter to automate the creating of a report that has a LOT of place holders. I 100% realize that there are ways to do this within Excel that would be much cleaner and much easier, but truthfully, I DO NOT have the skills to write the code for it. (The macro I am using was wrote by a wonderful member of these forums. (Snakehips))
Do I have any work arounds to the xlsm / mail merge debacle? Is there a method that I could do that doesn't require years of VBA experience?
to prepare an excel spreadsheet for a mailmerge but as all of the info for 1 recipient needs to be in columns instead of rows. I need to convert 2 columns' data into columns but only when there are duplicate invoices, see below;
I want to set up a one step button in an Excel workbook to open up a Word Mailmerge Document that I have already set up complete with Excel data source. I have used this code so far but it's not working. What else do I have to do?
Sub OpenWordMailmergeMasterB() Set appWD = CreateObject("Word.Application") appWD.Visible = True appWD.Documents.Open Filename:="X:Detention filesMail MergeLesley's MailmergeMASTER Interim Report.doc"
'To Run the Mail Merge 'Data source is a range name in Excel workbook called "MailmergeReport":.....................
I have a workbook that has multiple worksheets and I would like to use a command button to e-mail just one selected sheet. I want to create the single sheet as an attachment on a new e-mail message but leave the addressing to the user as it will vary, and not save the single sheet. My challenge is that the users have a variety of different e-mail clients (Outlook, Lotus Notes and others).
I want to generate a letter to parents that shares reading fluency data from an excel spreadsheet into a table and a chart. I got the info to post into cells in the table through mail merge. (sample below) Now I want to make a matching line chart to visually show the student's growth over time. I want the data on the chart to change according to the data I put in the cells in the table through mail merge. Is this possible?The data in the cell that says "Cory" and the "88, 100, 112" are placed in this table through mail merge. I want to now be able to take just Cory's information and display it as a line graph. If I highlight those cells and choose "insert a table" it doesn't work.