Outlook for Mac

Create personalized .pdf cover letters and attach each one to a corresponding E-Mail message in Outlook

Unanswered 0 answers

Older post from February 14, 2013. Details may be out of date.

Question asked on Feb 14, 2013
This is a question that involves using Excel, Word & Outlook. Please direct me to the proper forum if necessary.

I have an Excel document with the contact information (name, e-mail, etc.) for 500 employers.
I want to send out personalized cover letters to each one of them via e-mail.
I have a cover letter word document containing merge fields linked to the Excel document.

I need to do the following:
- Merge the cover letter word document with the Excel spreadsheet to create 500 separate and personalized .pdf files of the cover letter, each with a filename derived from the name of the company (Ex: "Cover Letter - Toshiba"; "Cover Letter - Samsung")
- Attach each one of the personalized cover letter .pdf files to a corresponding e-mail message in Outlook
- The e-mail messages themselves must also be personalized using the same information from the Excel spreadsheet

As a result, each employer would receive an e-mail message similar to the following, with the "<< >>" indicating the personalized fields.

------------------
To: <<*** Email address is removed for privacy ***>>
From: *** Email address is removed for privacy ***

Subject: Application for <<Sales Position>>

Dear <<Mr. Doe>>,

I would like to apply for the <<Sales Position>> at <<Toshiba>>. 
Attached please find my cover letter for your consideration.

Thanks,
Jane

Attachment: "Cover Letter - <<Toshiba>>"

------------------

If what I have described is not possible using the methods I described, please advise as to what methods I could use that would not require me to do any sort of manual personalization (ex: attaching each document one at a time, naming each file, or having to merge several times). 

Streamlining this process seems like a completely reasonable thing to be able to do with Microsoft Office, I imagine many people do it now just by using brute force. I hope I won't need to do that.

Any help is appreciated!

No answers yet

Write an answer

Your email address will not be published. Please never post passwords.

This site uses Akismet to reduce spam. Learn how your comment data is processed.