Solved

Access mailing list to Outlook for batch (list) send

Posted on 2002-06-16
7
185 Views
Last Modified: 2013-12-03
I hope this is a stupidly simple question. But it's necessary, because, as usual, Microsoft's docs tell you all about a process except how to do it.

I want to send a batch email (content*1; addresses*n) to Outlook, using a list of addresses created in Access 97. (Since this is a 1-time effort, it makes no difference if text is created in Access or in Outlook.)

I can do it for one addressee.  Is batching as simple as just creating one horrendous string of all the eaddresses, with commas in between?  Is there a length limit?

OR: What's the format of the "personal list" MS' documentation  talks about, and where does it go? Is it a  (by what) delimited list? or xml (what tags?)   Do names have to pre-exist in Outlook's phone book?  I'm hoping I can just create the address file (I don't need any other info there, so 1 column is fine),  tell Outlook to send to the filename and compose.  How DO I  tell  Outlook to send to "the filename"?

Are there any gotchas in the fact that this might be  created on a Win98 machine and sent from a Win2000 machine?

If it's not as simple as hoped, as for more points!

Thanks.

Marilyn Justman
0
Comment
Question by:mjustman
  • 2
  • 2
7 Comments
 
LVL 9

Expert Comment

by:ShaunWilde
ID: 7086573
if you can do it for one - why not just use a loop
0
 

Author Comment

by:mjustman
ID: 7090015
Shaun:
Good comment!  Now: Which loop?
The way I've got my code for 1 set up, the process would involve opening the Access Mail form (and possibly --but I don't know how Outlook works--Outlook) for each send, and having a real person "ok" each.   What I want to achieve is to use the power of Outlook to send 1 message to n addresses.

My own email client lets me create a one-column list of addresses in a file, and then put that FILENAME into the "to" slot, and voila --off the stuff goes.  (The replication happens at the smtp server; not before.) MS'  documentation suggests that you can do the equivalent with Outlook...but it involves setting up a Personal Directory (ok, I've done that) and .... here's the catch ... I think they want a specific file extension (and possibly unique format?) for the list, so that Outlook can see it.  If I'm right ... WHAT'S the EXTENSION? (and, if other than a 1 column list, what's the format?)

??

Thanks.

Marilyn
0
 
LVL 9

Expert Comment

by:ShaunWilde
ID: 7090300
hmm - do you have a list of addresses or can you enumerate them - sorry for being vague but I am not an Access developer but I have automated Outlook to access the emails so you'll have to fill in the gaps until someoe more knowledgeable starts to help
0
 

Author Comment

by:mjustman
ID: 7091663
Shaun:
It IS basically an Outlook question.
I have the list; I can have Access output it to a text file .. either delimited (with what character?) or  simply with a CR after each item.
I want to point Outlook at that file in the TO line  
TO:  Mytextfile[.txt?]
make up a message and send.

Thanks.

Marilyn
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10698050
Closed, 50 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now