?
Solved

Access mailing list to Outlook for batch (list) send

Posted on 2002-06-16
7
Medium Priority
?
194 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
5 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This article describes a technique for converting RTF (Rich Text Format) data to HTML and provides C++ source that does it all in just a few lines of code. Although RTF is coming to be considered a "legacy" format, it is still in common use... po…
zlib is a free compression library (a DLL) on which the popular gzip utility is built.  In this article, we'll see how to use the zlib functions to compress and decompress data in memory; that is, without needing to use a temporary file.  We'll be c…
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…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

809 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