I want to create a makro that loops until there's no more entries in my excelsheet where I get the data from. I.e. It should stop looping when there is a blank cell.
As a real beginner in VBA I'm not sure how I can insert som code into my existing code for that to work. I bet there's a real...
I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible?
Furthermore, I know that you can do something like: Set.subject /...
I am currently trying to create an Excel macro that converts my excel sheet into a PDF file and then sends it out by email. My current macro can do this, but it cannot convert it to a PDF file. I tried to merge my current VBA formula with the one here: to convert my excel...
I was using a CDO sub to send mail and it work great. I now have upgraded my computer and bought the
newest subscription for Excel. I am not sure what happened but the sub does not work any more. I
am hoping someone will be able to give me some code that will work. This has ruined my entire...
This is my first post so thank you very much in advance for any help..
I am trying to send individual mail from excel to three team members. I have member name range in C column, email id range in D column and file location path range in F column. My problem is when code is...
i have saved almost 500 mail copies in a folder. the task is to open all the mail copies and save them as pdf. the below code loops through the folder. however, i need help so that i can save each mail item as pdf. help would be highly appreciated
Dim objOL As Object
I've a monthly data base register with 50 plus members. I find few members are not entering data in specific cells or entering data which is out of date (EX: Actual end date is exceeding present date). I need to send mail every time to all defaulters. Please find my requirement below and anyone...
I have to setup a series of mail merged forms for my school to invite guest speakers to our classrooms. For that, I have setup a table called Guest_Speaker_MM.
I've already created all the merge fields and tested them using manual mail merge and they worked fine. However, when these files...
I am working in a mail merge document, and I need the output to look something like this:
However, the issue is that sometimes the fields are blank, and if they're blank it messes up the spacing. I want the document to ignore any blanks...
Hi I am not sure if this excel or word issue. I have a column in excel which has dates formatted as below. When I mail merge to word, I loss the format and the date will convert to something like that 30/09/20, instead of the format below. Why is that. Thank you so much...
Hope you all going good!!!
I need your help to get outlook email data into excel sheet.
Following details to be collect:-
1.From email address.
2. Mail Subject.
3. Mail body.
4. Also macro have to fetch data for customised dates.
Thanks in advance.
Thanks in advance
My Query is
My hosting account has a limit of sending only 200 emails/hour - 20 per minute. I broke my list down into sets of 200 to send out every hour. However, when using mail merge I can't find a way to control how many of these are sent per minute. Is there any way...
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...
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...
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"...