Mail Merge & Emails

[Roscoe24]

I have a small application, in which is a tblClient, indexed ClientID.

Each ClientID wants to send out various pre-set MS Word documents using Mail Merge. These specific documents need saving against that Client so that they can be accessed from the form frmClient.

Likewise, each ClientID sends and receives Emails. These also need saving against the ClientID and retrieved from the form frmClient.

I've been struggling with this for about 2 weeks now and am blinded by all the reading I've done on this forum - but still have no clarity on how to achieve these (simple) goals.

Any help appreciated.

 

[GiPSyFiSH]

For the linking of documents to the ID's, simply add an attachment field and put your documents in there? Or am I misunderstanding your question?

As for a mailmerge with word, look at my earlier post today.
LINK: (need more than 10 posts)

I'm sure there is a way to add the merged document as an attachment trough vba automatically after it is generated. Not sure how though.

for E-mails, no idea. Haven't tried this.

 

[Roscoe24]

Thanks for your trouble, GypsyFish.
- Mail Merge (outbound data) working perfectly from Temp table of captured data.
- Email (outbound data) working perfectly with Hyperlink
- Attachment Field certainly set me up in the right area. Not used them before - will now.

- Anyone else used storage of emails within system??