Solved

Access mailing list to Outlook for batch (list) send

Posted on 2002-06-16
7
187 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
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…

726 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