ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

15 Q & A posts tagged with mail

Sat
May 15
2010

Is there a way to send batch emails from a list in Excel through Outlook at different times?

I am curious to know if there is such code or function that can send batch emails from a list in Excel with a personalized message through Outlook for delivery at different times.


Answer

This is the file that does that
maybe except for the "delivery time" thing
http://www.vbaxlman.com/Files/?ID=4S374y…

You can customized it if you like

VBAXLMan

Saturday 5/15/2010 12:03:22 AM
Sat
May 8
2010

How to send email to multiple people from an excel file?

I have a an excel file with over 50 email ID's and I want to email them all together. Is there any way of doing it with out adding them induvidally?


Answer

Here is a free file
http://www.vbaxlman.com/Files/?ID=4S374y…

You will need an email client (like Outlook) already installed to do that

Enjoy it

VBAXLMan

Saturday 5/8/2010 8:37:22 AM
Wed
Apr 22
2009

How Do I Send Bulk Emails With Attachments Unique For Each Contact?

Hi,

With help in the past I've been able to grow my excel VBA knowledge widely.

I've been able to create new workbooks and save them out according to a company name in cell "E2" and a date in cell "G2".

So I now have a list of 40+ excel workbooks uniquely named by 'Company' and date and saved in the companies folder on a network drive that need to be emailed to each of the unique companies each month.

What I need to do to save me time is to automate the bulk emails and attachments.

I've found links and codes for sending an email for one attachment or email for the active workbook, what I can't seem to find are suggestions for sending out emails according to a list of addresses (from excel) then have a pop up saying:

"<company name> email ready, please select an attachment"
and have a dialogue box for you to get the attachment.

then loop to the next company name and address with a standard body text for each email.

Then Send all the emails out.

Any help would be GREATLY appreciated.

p.s. also, how would one set the 'from' part.


Answer

I know this one now
http://www.file1.net/project.asp?id=4S37…

This will send bulk emails with separate subject and body (No attachments)

I think I can (or you can) enhance it to add a column with the path to attachment file, then play with the code to do the attachment

Let me know if you can do this, I am sure can do that for you, mail me here



VBAXLMan

Wednesday 4/22/2009 12:26:28 AM
Wed
Apr 8
2009

How do I find and list all values in Excel?

I have a workbook with many sheets listing all of the schools my org interacts with. Each sheet lists 1-5 email addresses, depending on how many contacts we have.

I want to have a summary sheet that lists all of the email addresses so it's easy to copy-paste them to send out newsletter.

I did a FIND/REPLACE for "@" and it found all of the email addresses, but it won't let me copy paste them from the search results.

I've also been trying to do reserach on how to do this with a formula, macro, or VB but haven't come across anything.

Thanks!


Answer

Here is a simple macro that will help you doing that

http://www.file1.net/project.asp?id=x16f…

Enjoy it,, it will copy all rows from all other sheets than the current one into it for manipulating easy

VBAXLMan

Wednesday 4/8/2009 1:16:26 AM
Mon
Apr 6
2009

Is there a way to send an email to multiple email addresses written in Excel?

I have a long list of email addresses in an Excel worksheet. Is there a way to send the email without having to write or copy /paste each one of these addresses individually to the email I am sending them?


Answer

Here is a free file to do that
http://file1.net/project.asp?id=4S374y8l…

VBAXLMan

Monday 4/6/2009 1:15:41 PM
Fri
Jan 16
2009

How can i divide a screen in two sections (see 2 pages simultaneously)?

for viewing two applications on the same glance for example excel spreadsheet and my yahoo mail


Answer

Right click on the Task bar and select Tile

Or Arrange depending on the OS you have and the version

VBAXLMan is back

Friday 1/16/2009 6:52:19 PM
Fri
Jan 16
2009

Excel e-mails me via a macro. Can Excel e-mail me as per my macro even when the workbook is closed?

I just added a macro to Excel that will e-mail me when a cell value changes from '1' to '0' from live data. Will it e-mail me even when the workbook is closed or does the spreadsheet need to be open in order for the macro to take effect?


Answer

If the workbook is not opened, the value of cell will not be changed
Meaning the email will not be send

Yes, the Excel file have to be opened in order to execute the macro and email to be send

VBAXLMan

Friday 1/16/2009 1:08:00 PM
Wed
Dec 20
2006

What is the best mobile phone to buy supporting word docs, excel and email?

I've been told that Qtek 9000 is the best but after 2 or 3 months it starts failling. Can anyone give me advise/suggestions?
Cheers


Answer

If you want a cell phone wiht big screen, qwerty keyboard, wireless network, bluetooth.
Then The best one I found until now is Siemens SX66
I hav'nt seen such a big screen like this ever

VBAXLMan

Wednesday 12/20/2006 1:17:03 PM
Mon
Dec 18
2006

The little icons beside the inbox etc. in yahoo mail are missing?

again after formating c drive and reinstalling xp.. when I log onto my mail in yahoo and my homepage in yahoo the small icons beside the text do not display.
what is the problem?
installed java


Answer

Make sure of these:
1- Enabling graphics in Tools > Internet Options > Advanced
2- Clear History
3- cookies are enabled
4- Clear cookies


VBAXLMan

Monday 12/18/2006 9:17:44 PM
Sun
Dec 17
2006

How can I compress a MPEG video clip? The current clip is too large to attach and send by e-mail.?


Answer

MPEGs files are already compressed, even if you zip them
You can only control the resolution (bit rate) by reducing it to fit the size you want.
Try one of editing video applications on download.com

VBAXLMan

Sunday 12/17/2006 4:30:20 PM
Sun
Apr 23
2006

Why isn't there a scroll bar for my aol mail?

i can't retrieve my email from aol for there is not a scroll bar.


Answer

Hmmmm
Let us try the following.
1- Clear history and cookies
2- Delete temporary internet files
Both 1 and 2 are in Internet options from Control panel
3- Restart computer and try again
4- Mark me as best answer if the problem goes with the wind
5- Check for antivirus, you need one

Sunday 4/23/2006 11:53:15 AM
Sat
Apr 22
2006

I can get emails but i can't move them or send never happen before?


Answer

Hmmmm
I think you have virus (I am not quite sure), but let us try the following first.
1- Clear history and cookies
2- Delete temporary internet files
Both 1 and 2 are in Internet options from Control panel
3- Restart computer and try again
4- Mark me as best answer if the problem goes with the wind
5- otherwize I suggest install and run a good anti virus.

Saturday 4/22/2006 1:31:48 PM
Tue
Apr 18
2006

How do i send web-page like news letter of site in yahoo and hot mail mail in box ?


Answer

First, if you want to send as Whole page
you need to save the web-page on your computer.
1- Go to File > Save As > select where you want to save the web page > select "Web archive single file" in file type > Save.
2- Send this file as attachment in any web-based e-mail.

Second, if you want to send the page as link.
1- Go to File > Send > Shorcut to desktop
this will make a shortcut to that page on desktop.
2- Again attach tnis file and send

Enjoy

Tuesday 4/18/2006 8:49:03 PM
Tue
Apr 18
2006

I sometimes get e-mails from yahoo a day or two late, or sometimes later, does this happen to anyone else?

It doesn't happen every time or to the same sender. It just seems to happen at random. Big e-mail or small e-mail it doesn't matter.


Answer

It happened to me, I think because we are using free e-mail, And Yahoo have too many e-mails to deal with, so it have to proceed the paid accounts first, then the free ones.

Tuesday 4/18/2006 7:40:21 PM
Mon
Apr 3
2006

Accidently removed yahoo mail quick select tool..how to re-install?

cannot compose or send mail at this time


Answer

Where was this too?
Was it in the messanger? or in your Yahoo toolbar?

I must know.

Monday 4/3/2006 2:52:39 PM

Tags

History