mail

  1. L

    VBA new mail event

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

    MailMerge - Auto Delete Blank Columns?

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

    Many to One Mail Merge Currency HELP!!!!

    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!!!
  4. West Man

    Excel VBA with Word mail merge

    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?
  5. W

    Mail merge xls/csv crash?

    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!
  6. K

    Excel VBA Read Outlook Mail Where A Mail Has A Attachment.

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

    Sending mail from excel data to GMAILS using VBA Script

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

    Multiple Email body to same recipient

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

    Email attachment.add cell value runtime error 13 type mismatch

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

    Email attachment.add cell value runtime error 13 type mismatch

    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() ' '...
  11. G

    Gmail Smtp mail

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

    Macro to e-mail different sheets in a single mail to e-mail addresses present in excel sheet

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

    VBA: interaction Outlook/Excel, save mail in a folder and trigger a macro

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

    Mail Merge - multiple email in a cell

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

    Row Lookups

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

    Many to one mail merge - Please help!

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

    run word mail merge from excel

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

    Automatically Send Email When the date in time

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

    Extract first table of Outlook mail folder

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

    Stop returning results after the first match.

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top