Help with Outlook 2007 Macro Please!

Status
Not open for further replies.

Fabio

Member
Outlook version
Outlook 2007
Email Account
POP3
Hi

Can someone please help me with the following:

We have a restaurant with about 500 clients on our email list.

Every now and then we send *.jpeg* adverts for specials, functions etc...

Recently all ISP's here in SA have a limit of 20 email contacts per email ( for Anti SPAM purposes ). However they offer to create a distribution

list for you - at an extra cost and a great inconvenience ( with all the paperwork required ) for small users like us,

and if you need to change addresses you need to send them updated info that they will change in 48 hours....... and and and........

I would like to create, if possible, a Macro in Outlook that would:

1) Create Email

2) Insert Recipient ( 1 email per each and every contact from a distribution list either created in Outlook, Excel or Access )

3) Insert user determined Subject - This might be July Lunch Specials, Themed evening on the 20th... etc

4) Insert a *.jpeg* in the body of the HTML email ( NOT as an attachment )

5) Send! ( with Delivery and Read Receipt )

I would really appreciate if someone could help me with the above

Thanking you in advance

Fabio
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

Fabio

Member
Outlook version
Outlook 2007
Email Account
POP3
Hi Diane

Thank you very much for replying.

Your idea for a Template is perfect for me.

So what I would like to do is physically create a new mail, type in the subject and insert the advert in the body of the email

Then I would need a Macro to send this mail individually to a distribution list in Outlook that I will have open

Could you please send me a code for this. I have never worked with VBA / Macro before and am learning.

Thank you once again for your great help!

Regards

Fabio
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Try creating a message and saving it as a template - then use this macro. You can use the subject field in the template or add the subject in the macro -

Code:
Sub Merge_to_Group() 
 
Dim o_list As Object 
 
Dim objMsg As MailItem 
 
' select or open the distribution list 
 
' you need the GetCurrentItem function from 
 
' http://slipstick.me/e8mio 
 
Set o_list = GetCurrentItem() 
 
For i = 1 To o_list.MemberCount 
 
Set objMsg = Application.CreateItemFromTemplate("C:\path\to\test-rule.oft") 
 
With objMsg
 .To = o_list.GetMember(i).Address
 .Subject = "Test Subject" 
 
'  use .display for testing 
 
' .send to send the messages automatically
 .Display 
 
End With 
 
Set objMsg = Nothing
    
 
Next 
 
End Sub
 

Fabio

Member
Outlook version
Outlook 2007
Email Account
POP3
Hi Diane

thanks very much for your help

it works like a charm!

i introduced a time loop to delay msg sending

by 5 sec intervals

its working really well!

only prob is it comes up as spam :(

even from my own email address..

there's always something wrong

anyways thanks again!

fabio
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
J IPAD Outlook OWA App - Help using Exchange 2007 Using Outlook 4
D Outlook 2007 not working>> Please help tried everything Using Outlook 3
U Need a help please Outlook 2007 crashing Using Outlook 2
P help me plase !!! outlook 2007 I can see mail Bcc Using Outlook 1
Z Need Help Outlook 2007 inbox and address book view Using Outlook 2
D 2007 Outlook no longer connecting with AOL account. Help, small business! Using Outlook 1
L Someone on facebook hacked my Outlook Express 2007 password and changed it. Help Using Outlook 2
C Help with Outlook 2007 Using Outlook 2
W I have outlook 2007, and it is not saving my contacts when I send an email, please help! Using Outlook 2
J Re: Please help correct Error on step 4 of converting Windows mail to Office Outlook 2007(already installed). Using Outlook 3
T Installation help for Outlook 2007 with Business Contact Manager Using Outlook 2
C Outlook 2007 Business Contacts Manager won't install (and I can't get help from Microsoft) Using Outlook 2
M I am having trouble sending my e-mails in Outlook 2007. I can receive them, but not send. My internet provider says they can't help me. What to do? Using Outlook 6
C Outlook 2007 Calander help Using Outlook 1
J I can't open any links from my Microsoft Outlook 2007 e-mails. Please help me. Using Outlook 3
S Outlook 2007 help Using Outlook 6
G Stop automatic capitalisation fo first letter after hitting return!!!!!__I've searched for help everywhere. (Office 2007, Outlook). Using Outlook 1
N Outlook 2007/2010 , need help designing HTML signature that elegantly degrades to plain text Using Outlook 1
I Outlook 2007 instant search yielding no result even after extensive troubleshooting. please help! Using Outlook 2
C I need to transfer contacts files from Outlook 2003 with Windows XP Pro to a new laptop using Outlook 2007. Thanks for any help. Using Outlook 1
C Help setting up Email Accounts in Outlook 2007 with all folders (inbox, sent, junk mail, deleted items). Using Outlook 1
B Help! How do I create an e-mail stationary for MS Outlook 2007 Using Outlook 1
M Need help with multiple 'clickable' icons in Outlook signature for 2003 and 2007 Using Outlook 1
J Outlook 2007- Help Editing Meeting Makers - All Day Event option not available Using Outlook 5
R How to share distribution list by email in Outlook 2007? Method recommended by Microsoft Help does not work. Using Outlook 3
E _ Microsoft office outlook 2007/2010. Please help Ed Using Outlook 2
M outlook 2007 very slow to insert UNC hyperlink on windows 7 professional ... please help Using Outlook 7
D Please help me with a step by step for repairing my Win 7/Outlook 2007 to see the address book after migrating files using Win Easy Transfer from an X Using Outlook 1
J Help with Microsoft Outlook 2007 Using Outlook 0
D Help Please !! How to set Outlook 2007 to automaticly move junk mail from my inbox to the junk mail? Using Outlook 3
M HELP! Calendar in Outlook 2007 will not open Using Outlook 1
M How can I set up multiple e-mail accounts in Outlook 2007 / using Windows 7. Are there any more directions than offered in the Outlook help menu? Using Outlook 4
S Outlook 2007 keeps closing and restarting....help Using Outlook 2
P I need help with Outlook 2007!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Using Outlook 5
D Hi can you help me. I need a manual to set up an email account in outlook 2007 on my new 64-bit laptop with windows 7 (not vista) Using Outlook 0
J Outlook 2007 keeps prompting for password after update, please help! Using Outlook 11
L Help for writing an Outlook 2007 macro Outlook VBA and Custom Forms 7
T need help w/ sending an e-mail -- outlook 2007 addin Outlook VBA and Custom Forms 2
C Outlook 2007 Wacky Issue - Please Help Outlook Wishlist 1
R seperate read layout to design in outlook 2016..Help!! Outlook VBA and Custom Forms 3
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
C need help setting up outlook first time Using Outlook 1
S help with outlook scripting Outlook VBA and Custom Forms 4
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
N Outlook Forms Help Outlook VBA and Custom Forms 2
K Help.... Office Outlook 2016 Using Outlook 1
EaglePI Outlook 2010 need help with rules Using Outlook 0
Jeff Davis Help fix my Outlook 2013? Using Outlook 28
C Newbie needs help with Outlook Macro Outlook VBA and Custom Forms 3
Similar threads


















































Top