Hi guys,
I have an excel file with a table, where I have clients and providers emails in column C.
I have the subject in cell G4
And I have the body of the email in cell G5.
I have a code written, but, it's not working as expected.
I was trying to loop through column C and past the emails to...
Hi All
I am working on a macro for an Email that will send some request to recipients. We are scrubbing the data on the responses so need them to respond in a certain way. I am trying to get the templates to auto-populate in the return email. I currently have the below coded up which is giving...
i have a problem with the code that i have, when it emails the workbook it wants to update the cell information, regardless of what you click update or dont update it changes the cell values to VALUE. withing the cells is a hard link to the workbook ... c:\xcl\Test.xlsm
is there a way in the...
Hello,
So, with help of kind people here I was able to make most of my project work, but have hit the hopefully last bump. Basically, I have a worksheet that based on condition decides whether the issue should go after Quality, Logistics or Finances, and then generates an email to be just sent...
Hello,
First of all, I am still new to VBA and more complex excel coding, so I'm learning by doing, searching forums and tutorials, stitching together bits and pieces of code I need. However, I ran into a dead end and would need help. Basically, what I'm trying to do: I have a project to sort...
Hello, first post. Will appreciate any help - even just a pointer to the correct place to look.
I'm struggling to word this requirement but here goes:
I have a data table in excel (a proper table). Each record contains a student and several other fields of use. It also details the teacher, and...
Hello, my first post.
I'm looking for a solution with my Excel VBA problem.
Hopefully someone is able to help.
I'm looking for a solution to send multiple emails with outlook to different mailadresses with different rows from my excel file.
Employee name
Email address
Info 1
Info 2
Info 3...
Hi All ,
I would like to request an advice how to send multiple group email based on a cell content. Currently i have a table that contain , name , country , email , cc , subject.
The current existing macro that i have is able to send an email individually within the table.
I am testing out and...
Good evening,
I'm very inexperienced with VBA, but would like to be able to have Excel draft and send an email based on options selected from a dropdown. The subject of the email along with the body of the text also need to have values from cells inserted.
For example: "Yes" selected from...
Below code works, except that instead of a Signature that I have designated as default in Outlook to be added to all my emails, this code picks another signature.
- How do I fix it for it to pick a Signature that I have designated as default in Outlook to be added to all my emails?
Playing...
Hi,
I'm totally new to Macro and I would like to know if it is possible to save the email in the Outbox of the Shared Mailbox.
I understand ".Save" will save it in drafts, but it had to be saved in the shared mailbox not in my personal email.
For some context, I need to create multiple emails...
Hi All,
I am looking for a code that will help me copy a workbook and fill it with information from another workbook.
i already wrote a code that creates a copy, now i need a code that it will take information from the source workbook put them into the workbook i just copied, i hope i have...
I am working on contacts sheet which I need to get the name from email.
Multiple cases I have to faced and with the help of below post link, I formed the sheet below.
Extract name and company from email address
Case 1: The mail id may contain separators like dot, dash and under-score
Case 2...
Hi,
I have a substantial (and dynamic) list of names that I'm needing to transform into email addresses.
For names like Bob Smith, and even those with hyphens (Sarah-Jane Brown), it's no issue:
=LOWER(CONCAT(SUBSTITUTE(SUBSTITUTE(C16342," ","."),"-",""),"@abc.com"))
End result =...
Hi there, I'm looking for some help with drafting an email to Outlook from excel.
The Image below shows a typical sheet information. Each column has different data which is needed in one of the email fields.
I would like to be able to press a button and have a draft email appear to the...
Good afternoon,
Hoping to get some help on this one.
I have a file that has a list of jobs, my boss will then put a % to each one of these jobs in E starting from E6.
Once that percentage hits 100%, I would like it to send an email to our billing person, that says something along the...
Hi,
I keep getting Compile Syntax Error when trying to run the following Macro. Please Help!
Sub Give_Feedback()
Dim EmailApp As Object
Dim EmailItem3 As Object
Dim xStrBody As String
xStrBody = "Good Morning/Afternoon" & "<br>" & "<br>" _
& "My feedback is about:" & "<br>" & "<br>" & "Kind...
Hi i hope you can help me since i have been trying this for weeks.
I need to find a way for excel to send an automatic email to a specific adress IF any value from a column changes its value to a specific text. The value in question is text, so for example:
- If C5 changes to "Done" then an...
Trying to exclude sender when recipients hit Reply All, in Excel generated Outlook email.
I have:
EmailItem.To = "email2@email.com"
EmailItem.CC = "email3@email.com"
I think I can do:
EmailItem.ReplyRecipients.Add "email2@email.com; email3@email.com"
But how do I do that without...
Hi, I am trying to create an email in outlook using VBA.
In the email i want to include text and a formatted table from the spreadhseet.
In addition i want to add an image/shape to the BOTTOM of the email, but I can't seem to get it to land there.
Here is the code i have managed to put...
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.