mjustman
asked on
Access mailing list to Outlook for batch (list) send
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
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
if you can do it for one - why not just use a loop
ASKER
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
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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.