Windows

General discussion

Gravatar
Locked

Email merge with attach. - VB template

By steve.doig ·
G'Day Folks,

I have ~200 email addresses that a standard letter and personalised schedule need to be sent to.

I want to create a template that will match the email's nickname (eg JSmith) with JSmith.txt containing the schedule.

Can I make Outlook or similar send this 'welcome' email to all contacts in an non-standard address book and attach the txt file according to the email's nickname?

Any suggestions that produce a good result are welcome.

I'd prefer not to use a database at this stage, but will do so if abs necessary.

Cheers and regards,

Steve Doig

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Email merge with attach. - VB template

by DKlippert In reply to Email merge with attach. ...

There are a couple of solutions for your project. Here is a location that discusses alternatives depending on your version of Outlook and/or Word.

http://www.slipstick.com/contacts/startletter.htm.

(There are no spaces in the URL)
Here are acouple of more ideas:

http://www.mvps.org/word/FAQs/MailMerge/MMergeIfFields.htm
http://www.mvps.org/word/FAQs/MailMerge/MMergeQueryOptions.htm

Word is a great app for this purpose. You can not only use Outlook as a address source, but you can also use If..Then statements to either include files or AutoText.

gravatar
Collapse -

Email merge with attach. - VB template

by steve.doig In reply to Email merge with attach. ...

I found the resources above to be interesting, but didn't immediately solve my problem. If I could, I'd give you half marks for the information.

gravatar
Collapse -

Email merge with attach. - VB template

by steve.doig In reply to Email merge with attach. ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Start or search

Related Forums