If what you are looking for is not mentioned, please message me. *MS Office – all functions of Word and Excel Read more I've been in the administration sector a decade and hold not only experience but qualifications within administration, personal assistance, virtual assistance and business marketing.ĭo what you do best, outsource the rest! Leave your business requirements for me to handle so you can focus on other things. ![]() That's it, off to the races.I've been in the administration sector a decade and hold not only experience but qualifications within administration, personal assistance, virtual assistance and business marketing.ĭo. While in Word, begin the "mail merge" process, accessing the Excel workbook with the data, finish the process by pointing Word to the email addresses in Excel. Click the following button to make a copy of the Gmail/Sheets Mail Merge sample spreadsheet. "In a nutshell," type your message in Word - insert "placeholders" where you want specific information, e.g., names, addresses, etc, Have those data in an Excel worksheet, preferably in the same sequence as they appear in your message, in addition to the individual email addresses that go with those data. Of course I guess it's possible to formulate a program to automate the process even more, and perhaps even more applicable if one is not using Outlook or Word? I've only done mail merge with the above. If one is using Excel for the database, Word as the word processor, and Outlook as the email vehicle, then one need not do any VBA programming. So forget the word, "script" and in its place simply use the word "message" ![]() Personally, I have never, ever seen "script" used in place of macro. If someone would let me know which is most appropriate, I'd be happy to help. This is my first post on here and have no clue if I can attach my instructions or copy and past them in a reply. The actual mail merge itself only takes a few seconds to complete. The time involved is setting up the data and getting your script written the way you want. I have been able to send out hundreds of emails in several seconds, about 30 seconds for 250 emails. Then you proceed to mail merge in Word and "connect" to your Excel file that has your specific information. ![]() In Excel you'll create a database with the variable you want in your email, e.g., personame and departmentname, along with the email address. What you are doing is making "placeholders" in your verbiage, to hold the associated information that is located in Excel. ![]() I also highlight in red so I can easily identify it both in the script and when emails are answsered, e.g., Dear : you are receiving this email because your department has been selected to. Every place you want a "variable" - e.g., a person's name, possibly their age, what department they work in, whatever, enclose that "variable name in brackets for ease of identification and location in your script. To paraphrase - generate the script/verbiage/note you want to send in an email in Word. I say "most likely" because it is somewhat simple if you have Microsoft Office for Excel and Word! I have a set of instructions I wrote up at work I could forward to you IFF (if and only if) you have Word 2007 and Excel 2007, or possibly later. I agree with "macropod," there is, most likely, no need to write a VBA program.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |