mail

Hi Team I would like to send a mail from excel with the info from - specified columns - Specific email body Please see screenshot - SDA email - that should be To - TL Email - That should be in CC - Reason and INC/WO should be in subject with line "Returned Ticket...... - Email body - "Your...

Hi All, When doing Mail Merge, is it possible to send individual customer with individual different excel worksheet in each email as an attachment? Cheers, Peter

Can someone help with the coding to save a letter template in Word that will fill with each persons name (column a) via mail merge and then save each page as a unique file name under (column B)?

So I have 2 worksheets. Sheet 1 contains 425 rows and the last column being used is O currently. The first column contains a unique identifier number. Sheet 2 is used to send out mail merges it contains less rows until it is filled and the last column being used is S currently. Now in Sheet1...

I have a table, listing about 500 people that have been issued between 1 and 12 roles each. Each row of the table has a role. So, if Mr Smith has 12 roles, he will appear on 12 rows. I want to do a mail merge which would send one email to each person that lists their roles. I can't work out how...

Hi , Shall some one help to to fetch the report from outlook in excel condition is below 1) Check all today's mail from inbox and check in sent box whether we replied or not. 2) In report get all mail by sub line mark red to all not replied mail OR in next column print "yes" if replied "No"...

I have a list of clients to which i need to send mails. However due to service provider restrictions, i can send these mails at an interval of 10 secs only, or else my domain gets black listed for spamming. I need a VBA code where the comman mail body is used to send the mails to a particular...

<tbody> Billable / Non-Billable Electronic / Mail Page Cost search Fee Y/N Search Fee PDF Postage Total Billed Billable Mail $$ Y $10.00 $6.50 $$ =$$ Billable Electronic - Y $10.00 $6.50 - =$$ Non - Billable Mail or electronic 0 N - - =$0 Non- Billable...

Hi all, i am using this code but want to few changes, please help Private Sub CommandButton1_Click() a = Worksheets(“Sheet1”) .Cells(Rows.Count, 1) .End(x1Up) .Row For I = 2 To a If Worksheets (“Sheet1”) .Cells(I, 3) .Value = “North” Then Worksheets (“Sheet1”) .Rows(i) .Copy...

Hi All First time trying to do this: I am trying to print labels from my Excel spreadsheet with Word using mail merge. It's a XLSM that I changed to XLSX. When Word tries to open the file, I get this message: This workbook contains unreadable content and cannot be opened. Any ideas? Thank you!

Dear All , I use IBM lotus mail software. I create a macro which get some data from excel and sent to related people. However I couldn't send data with "richtext" format. Therefore mail content is really messy. How can I send e-mail with "richtext format" . Please help me. You can find my...

Hi Guys. I managed to slim down our shift changeover document by changing from Outlook mailing, to MailEnvelope. The process is O.K. I had to do this as multiple of our guys had issue starting up outlook. (Corporate runs addons that are heavy) Now I am stuck on how to allow them to add...

I watched a youtube video called Mail Merge Multiple Rows into One Document in Microsoft Word. I did every step he showed but my end result never works. I type out the code he says and it is suppose to turn into the end result but when I do finish merge it just say in code. What am I doing wrong.

hello I'm writing a macro for: 1 add something in the object 2 forward the mail, 3delete it 4 open the next one. 5 open the attchment stop macro I was able to write the first 5 point but I'm getting crazy for the last two, which is open the mail after and attachment as well. could you help...

Ultimately I am aiming to have a mail merge document whereby the user inputs a variable which filters on that input and produces the mail merge purely for the row that has that code. At the moment the coding doesn't include the variable as I've been unsuccessful in getting the filtering to...

Hello, I need an EXCEL VBA script which will perform the following operations: 1. Open my Outlook 2. Read mail with a particular subject line (let's say ' TEST MAIL') 3. Download the attachement from that mail to Desktop location. Please help me with the script. Thanks,

Hi, can anybody help me with task to check if email address is correct? I dont mean format, but if it bounces without sending an email. There are online services to do that for some price so it is possible to do it somehow(they were correct for my company mail, personal mail, gmail etc.). So...

Want to run a macro which can do mail merge and save that document in PDF Format with the First name and second name combination in a specific location

Hello all. I have been using mail merge for some time now. However, I think I have been doing something wrong. You can see this simple table below. So when I do a mail merge, it take the information horizontally which is perfect. Here is the issue. The last column is students. I have a...

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