Mail Merge - Attaching Different Files to each user - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Mail Merge - Attaching Different Files to each user

Tanchi Avatar
6y, 11m agoPosted 6 years, 11 months ago
Hi All,

I have 56 emails that I need to send to 56 individuals. each email contains information that is for there eyes only, Ussaly I would do a Mail Merge, however each user must have a file attached that is unique to them.

Is there any way I can do this?

Tanchi Avatar
6y, 11m agoPosted 6 years, 11 months ago

All Comments

(3) Jump to unreadPost a comment
You need something like this.

Function Send_E_Mail()

Set rsE_Mail = CurrentDb().OpenRecordset(("INFO"))

Set EmailApp = CreateObject("Outlook.Application")
Set NameSpace = EmailApp.GetNamespace("MAPI")
Set EmailSend = EmailApp.CreateItem(0)

With rsE_Mail
Do While Not .EOF
EmailSend.To = strEmail
EmailSend.Subject = Message
EmailSend.Body = strBody
'EmailSend.Attachments.Add ""
EmailSend.Display ' Remove this line if you don't want to see email
End With

Set EmailApp = Nothing
Set NameSpace = Nothing
Set EmailSend = Nothing

End Function
uh-oh this looks compucated
What does the file attachement contain. If its just information you can add that information within the mailmerge function as another line.

Alternatively still using mailmerge, if the attachements can be published to a secure website you can link to the customers individual data file using a single web address as the mailmerge field

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!