mail

Hello guys, I'm trying to replace people at my work and the next step is running specific macros when certain emails are received. I am using office 365, and I'm not sure what is going wrong. I found multiple examples, but none of them seem to work, an example...

Hello! I’m not sure if this is an excel question, word question, or combination of both. I export data daily to a CSV (my only option). Same 200 columns every time. Sometimes though, each column doesn’t have a value. Imagine columns A, B, and C. One day those will all have a value, one day B...

I am trying to do my many to one mail merge like i always do but when i add "amount" to show the total for each item due it doesn't show the "$" just the number. Help!!!

Can I record a word mail merge macro and then call it from Excel with VBA, come back to Excel and update records with the date the mail merge was run? Is there a better approach?

Hello, I'm doing a mail merge from a spreadsheet to word. When I select the spreadsheet via word it only works if the spreadsheet is saved as a csv. If the spreadsheet is saved as an xls when I try and load the list of recipients from word, word crashes. I've got no idea why. Any ideas? Thanks!

Hi, I want to read Outlook mails from Excel vba, but only those mail that has attachments, I am using below code, but I don't know it is not working accordingly. What I catch here is that I thing it is also reading those mails where the image is pasted in a mail body as well. Public Sub...

Hello Guru’s I would require your help on below requirement. I am new in VBA script this is my first attempt. Currently am sending mails one by one with manual change in below code. Now I am planning to change code in automation way. I have excel with data as below. <tbody> SNO Name Mail ID...

Hi, I wrote a VBA Code to send a mail to the recipient based on a criterion. My next step is a bit complex and I am not sure how to proceed. Problem: I have a criterion, passing which, a mail will be sent to a recipient. But there shall be several instances where the criterion is TRUE and...

Hi! I would like to attach different types of file to my emails. This code worked well and sent emails untill I placed the attachment adding. .Attachments.Add "D:\8" & Range("S12").Value After that it was stucked on runtime error 13 type mismatch. Can anybody help me with this...

Hi! I would like to attach different types of file to my emails. This code worked well untill I placed the attachment adding. .Attachments.Add "D:\8" & Range("S12").Value After that it was stucked on runtime error 13 type mismatch. Can anybody help me with this? Sub Send_Mail2() ' '...

Hi, Please find the VBA code i am using to send mail.Getting error .(Run time Error '-2147220975(80040211)' : The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available) Tried to disable two step verification and enable...

Existing Macro:- I have an existing macro with a send Email button on clicking it will send separate mails with single attachment to all the owner.present in the excel sheet. Requirement:- while clicking on send mail button it should first pick an owner i.e. mail recipient from coloum D of...

Hello everybody. Every hour I receive a mail from the address example@example.com (no others mail are received from this address). I need two things: 1) save the attachment in a specified folder (received in csv.7z, saved in xls); 2) trigger a macro from vba Excel that is supposed to elaborate...

Hi All, Just have a quick question for the community, quite a complex mail merge just tying to find out what the best way to get to the solution. I’m trying to create a mail merge, into a word document and then to be sent out via outlook (I am on office 2016) data source is in excel. However...

Hi, I am a bit stuck and was wondering if anyone has any ideas. I have an extract from Exchange that has data similar to this..lots of rows but need a formula that searches each row for "*newmail.com" and appears in the NEWMAIL column (C): <colgroup><col width="75" style="width: 56pt...

I was using many to one mail merge religiously until my work re-imaged my computer to Windows 10 and now i can't seem to get it to download on my computer. Can anyone help me and tell me what i am doing wrong? i go to extract the file into my App-data but the files i need are not there. Is there...

hi all i have sheet witch contain data and i fill data on it then it's calculate , finally i close it and go to word document witch already have letter mail merge , then i print some of it , maybe record #1 , maybe from record 1 to 50. i want to use macro to run it from excel to 1.run mail...

Automatically send mail our measure point is the "DATE" when it's in the place send the mail our mail is depends on the cells in the excel I will provide a picture to explain what I mean https://ibb.co/iK3bxK I think from the image now you understand what I mean Thanks.

I'm trying to extract first table of each mail of a specific folder to Excel. If there is more than one table in the mail we can exclude it and move to next mail item. Below is the code I have at the moment. Could you please hel <code style="margin: 0px; padding: 0px; border: 0px; font-style...

Hoping this is possible. In B I have a list of papers In X there is an IF(AND formula which tells me whether a product type (EU) is suitable for the paper or not. Where there are multiple papers, I'm seeing multiple EU's - I only want one, however. <tbody> B V W X Preferred X Result...