Welcome, Register for free! or Login below:
EduGeek.net RSS Feeds Register FAQ Members Social Groups User Map Calendar Search Today's Posts Mark Forums Read

Scripts If you need or have any scripts then get 'em here.

Go Back   EduGeek.net Forums > Coding and Web Development > Scripts
Reply
 
LinkBack Thread Tools Search Thread
Sponsored Links
Old 19-06-2009, 03:11 PM   #1
 
ahankiewicz's Avatar
 
Join Date: Mar 2009
Location: Bedford
Posts: 22
uk uk bedfordshire
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 ahankiewicz is an unknown quantity at this point
Default VB or Outlook Macros

I have little experience of programming of VB or Outlook macros however I need to create the following:

A method to send bulk emails to parents within the school (this would include letters home for events, term newsletter etc.

I can create either a mail list in Outlook or using the same info in an xls spreadsheet.

All email must be sent in Bcc address, Subject of the letter, in the main part of the mail there must be a salutation, one or two line of text and the an attachment in pbf format.

Does anyone have the right method or script?

Andrew
  Reply With Quote
Old 19-06-2009, 03:16 PM   #2
 
ChrisH's Avatar
 
Join Date: Jun 2005
Location: East Lancs
Posts: 4,429
uk uk lancashire
Thanks: 21
Thanked 103 Times in 94 Posts
Rep Power: 35 ChrisH is a glorious beacon of light ChrisH is a glorious beacon of light ChrisH is a glorious beacon of light ChrisH is a glorious beacon of light ChrisH is a glorious beacon of light ChrisH is a glorious beacon of light
Default

Mail merge to email?
  Reply With Quote
Old 19-06-2009, 04:25 PM   #3
 
ahankiewicz's Avatar
 
Join Date: Mar 2009
Location: Bedford
Posts: 22
uk uk bedfordshire
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 ahankiewicz is an unknown quantity at this point
Default

Yes - send a mail with content & attachments to a number of addresses. I would like it to be automated (no knowledge required!)


Andrew
  Reply With Quote
Old 19-06-2009, 04:30 PM   #4
 
mac_shinobi's Avatar
 
Join Date: Aug 2005
Posts: 4,414
uk
Thanks: 345
Thanked 329 Times in 309 Posts
Rep Power: 71 mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future mac_shinobi has a brilliant future
Default

find attached a silent MAPI emailing project done in VB 6 - may or may not be of any use - got this from a person on experts exchange
Attached Files
File Type: zip eglOEmailer.zip (26.4 KB, 6 views)
  Reply With Quote
Old 19-06-2009, 06:09 PM   #5
 
sahmeepee's Avatar
 
Join Date: Oct 2005
Location: Greater Manchester
Posts: 800
uk
Thanks: 19
Thanked 65 Times in 41 Posts
Rep Power: 22 sahmeepee is just really nice sahmeepee is just really nice sahmeepee is just really nice sahmeepee is just really nice
Default

You could also look into using a commandline email program like blat if you want to do it via a batch or vbscript.

I would go with ChrisH's suggestion first given your stated level of experience.
  Reply With Quote
Reply

EduGeek.net Forums > Coding and Web Development > Scripts

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros in Excel 2003 LeonieCol Office Software 1 08-05-2009 04:09 PM
Enabling macros across the network silver Office Software 15 03-04-2009 12:11 PM
[MS Office - 2003] Access - Conditional Macros garethedmondson Office Software 5 27-01-2009 01:06 AM
Migrating to Outlook 2003 from Outlook Express Mintsoft Windows 3 05-07-2007 09:42 AM
Mandatory Profiles and Macros Midget Windows 3 24-01-2007 06:07 PM



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search Thread
Search Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:38 PM.
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.
Copyright EduGeek.net




website uptime

© 2005 - 2010 EduGeek.net
SERVER: 4
no new posts